I am working on a costing spreadsheet and would like to use a formula to come up with the correct cost depending on a couple of variables. Column G = Price/Unit

Different Sheet = Cost Conversions (VLOOKUP(A2,'Cost Conversions'!A:J,9,0)So, I want the formula to take the price from column G if it is less than $10.00. If it is more than $10.00, then I want the formula to take the price from the vlookup. Is this possible?

Thanks,

Heather

✔ Best Answer

It would look something like: =IF(XX1<=10,G?,IF(ISNA(VLOOKUP(A2,'Cost Conversions'!A:J,9,0)),G?,VLOOKUP(A2,'Cost Conversions'!A:J,9,0)))

MIKE

With only the supplied info, the best I can offer is somthing along the lines of: =IF(XX1<=10,G?,VLOOKUP(A2,'Cost Conversions'!A:J,9,0))

MIKE

Ok. Thanks. Is it also possible to add an if n/a clause to this? For example, if the final cost comes out to n/a, can it take the cost from column G?

if the final cost comes out to n/aDo you mean the Excel Error code #N/A ?

MIKE

Yes, the error code #N/A.

It would look something like: =IF(XX1<=10,G?,IF(ISNA(VLOOKUP(A2,'Cost Conversions'!A:J,9,0)),G?,VLOOKUP(A2,'Cost Conversions'!A:J,9,0)))

MIKE

Great. Thank you so much for your help.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History