If & carried forward balances

  • Hello.


    I have attached a sheet which gives a benefit based on a benefit code from 1-9


    The formula I created in range C8:C16 was created to validate based on quote in column A & ADA schedule in column D


    Although this links to column H, I wonder if VLOOKUP formula could incorporate the benefit codes instead? Not sure how to setup


    Column F is designed to give the lowest of the quote, ADA schedule or limit (range F2:F5)


    I have spent hours trying to figure out the best formula for calculating the balance carried forward in F8:F16, I need the result to be either the maximum (highest) result if more than column C or D from range F2:F5


    I have a formula which does sort of work but is incomplete


    Thank you

  • Re: If & carried forward balances


    Do you mean replace the direct reference to column H with a Vlookup?


    e.g.


    [COLOR="#0000FF"]=IF(D8>0,D8*B8, A8*VLOOKUP(E8,$G$8:$H$16,2,0))[/COLOR]

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!