Multiply result of IF function in same cell

Hi all,

Using Excel 2010 and I've attached a sample file.

My current formula in cell B4 says:
=IF(B3="FlyCasting","$5",IF(B3="Archery","$5",IF(B3="FlyFishing","$5",IF(B3="Biking","$5","$0"))))

I would prefer in cell B4 to automatically multiply the result of the above formula by the number in cell E3 but only if B3 is “FlyCasting”,”Archery”,or”FlyFishing”. If B3 is “Biking”, the formula should stand as-is with no multiplication.



Is this possible?

Thanks!

Sample.xlsx

What about...

=IF(OR(B3={"FlyCasting","Archery","FlyFishing"}),5*E3,IF(B3="Biking",5,0))

Hi,

Because you have cell B4 formatted as currency, you don't have to enter the dollar sign.

This modification to your formula should do what you want

=IF(B3="FlyCasting",5*E3,IF(B3="Archery",5*E3,IF(B3="FlyFishing",5*E3,IF(B3="Biking",5,0))))