microsoft excel course london - Vlookup/sumif

Hi Andrew,

Thank you for the question. You are not able to nest the Vlookup and the if/sumif formulae, however, how about looking into the possibility of putting the AND and OR functions into the IF function??

I will give you an example

=IF(OR(G8="NA", "H8="No"), "No bonus", F8*1.5%))

so you would be in the detination cell and if either of the cells are NA or No the cell will return No bonus, if that is not the case it will return whatever F8*1.5% is.

Alternatively you could try

=IF(AND(H8="Yes", F8>12000), "Yes", "")

and the standard IF conditions apply.

See if you can get around it that way

Tracy