if statement with three possible outcomes

Hello everyone,

I have a workbook where i want to create an if statement with three possible outcomes.

Cell A2 = Price
Cell B2 = Amount
Cell C3 = Total

Outcome 1: If any number is in Cell A2 & B2 then C3 = A2*B2

Outcome 2: If nothing is present in B2, but anything is present in A2 then C3 = A2

Outcome 3: If nothing is present in A2, but anything is present in B2 then C3 = an empty/blank cell

I didn't attach a workbook because there's really nothing to show. Can anyone help me create a formula for this scenario? Thank you in advance.

Try:

Formula:

Please Login or Register  to view this content.

works well, thank you!