I need to combine an If Statement with a VLOOKUP.
I have a cell (P3), where I'd like to populate the sales price of an item. I have a Vlookup in that cell as follows:
VLOOKUP(B3,Sheet3!A$2:C$13,3)
But, one of the items in the Vlookup has one price if if it <=107,999 pcs, and another price if it is >=108,000 pcs. So, I need an IF Statement that would look something like this:
=IF(B3<=107999,0.0242,0.0217).
How can I combine these two statements?
I have a cell (P3), where I'd like to populate the sales price of an item. I have a Vlookup in that cell as follows:
VLOOKUP(B3,Sheet3!A$2:C$13,3)
But, one of the items in the Vlookup has one price if if it <=107,999 pcs, and another price if it is >=108,000 pcs. So, I need an IF Statement that would look something like this:
=IF(B3<=107999,0.0242,0.0217).
How can I combine these two statements?