Multiple IF AND OR statements HELP

[kulin]

I want to perform a simple multiplication. I have two columns with default values (G9 and H9), and two columns that the user can put personalized information (E9 and F9). I want the calculation in column I9 to default to G9*H9, however there are three other scenarios that are preferred than the default. The best scenario is if E9 and F9 have information in which case I want this output in column I9. The other two situations is if E9 or F9 have information, but not simultaniously, in which case I would want E9*H9 or F9*G9.


My attempt has been the following

=IF((AND(E9<>0,F9<>0),E9*F9,G9*H9), OR(AND(E9<>0,F9=0),E9*H9,G9*H9), OR(AND(E9=0,F9<>0),G9*F9,G9*H9))

I appreciate your help!

 

[Snakehips]

kulin,

Welcome to MrExcel.

Try.... =IF(AND(E9<>0,F9<>0),E9*F9,IF(E9<>0,E9*H9,IF(F9<>0,F9*G9,G9*H9)))


Hope that helps.

 

[mikerickson]

Try

=IF(E9=0,G9,E9) * IF(F9=0,H9,F9)

 

[kulin]

Thank you SO much! Have a great day