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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History