Combine VLOOKUP and IF Formula

[blenz250]

Hi, I am trying to combine the 2 formulas in Cell G4

VLOOKUP(D4,PriceList,5,FALSE) and IF(G4<100,G4*1.4,G4)

What I am trying to accomplish is if the price value that is found in column 5 is less than 100 I would want the value to be multiplied by 1.4 and placed into cell G4. If the price value is over 100 then I would like that value left alone and placed into cell G4.

I would like to do this in column G and not have to do multiple formulas in multiple columns.

Any help would be greatly appreciated.

[Craig K.]

Assuming your vlookup is the value you have in cell G4, just replace every instance of G4 with your vlookup, like this:

Please Login or Register  to view this content.

This is called a nested function

[Aardigspook]

Without seeing the source data, it's tricky to be sure, but from what you've said, this should be the combination of your formulae, to be placed in G4:

Please Login or Register  to view this content.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

[blenz250]

Thank you very much for your quick response, actual formula, and explanation of what it actually called. Much appreciated.

[Aardigspook]

You're welcome - Craig K explained it a bit better than me, as well as being faster to the draw...