How to combine 2 separate IF statements with different outcomes?

[melora]

I have 2 Products. Product 1 has varying adjustment percentages, Product 2 does not.

Both products can be paid for in USD or SGD.

How do I combine the formulae for:
1) IF Product 1, multiply by the adjustment
2) IF USD, multiply by the FX rate

I've tried searching up combining IF statements, but I can only find answers on how to combine multiple criteria.

Please help! TIA!

[ORoos]

Hi melora,

in cell E4, try: =IF(B4="USD",$B$1*D4,IF(ISNUMBER(C4),C4*D4,D4)) and pull down.

[melora]

Hi ORoos, thank you so much!!! That works perfectly!

[ORoos]

Hi melora,

In the formula, instead of referring to Product 1 to use the 'adjustment' the formula will look for a number in that column. So if it is N/A, then it will not multiply the adjustment.

IF your query is answered. Please mark it as SOLVED via the Threat Tools at the top of your original code.