Multiply cells in single row if cell is not blank

Suz Raphael

Referencing the attached image, I want to multiply the Pricing cell by the Seats/Multiplier cell, but only if the latter has a value/is not blank (obviously irrespective of row, ignore that part in the formulas).

So if this works:

=Pricing13 * [Seats/Multiplier]13

And this works:

=IF(ISBLANK([Seats/Multiplier]2), Pricing2)

And this works:

=IF(NOT(ISBLANK([Seats/Multiplier]14)), Pricing14 * [Seats/Multiplier]14)

Why doesn't this work:

=IF(NOT(ISBLANK([Seats/Multiplier]14)), Pricing14 * [Seats/Multiplier]14), IF(ISBLANK([Seats/Multiplier]14), Pricing14

Or more importantly, how can I more simply formulate elseif?

Thanks in advance!!

Emily Zeiger

Too many parenthesis. Try =IF(NOT(ISBLANK([Seats/Multiplier]14)), Pricing14 * [Seats/Multiplier]14, IF(ISBLANK([Seats/Multiplier]14), Pricing14

Emily Zeiger

Too many parenthesis. Try =IF(NOT(ISBLANK([Seats/Multiplier]14)), Pricing14 * [Seats/Multiplier]14, IF(ISBLANK([Seats/Multiplier]14), Pricing14

Suz Raphael

Thanks, Emily! What a difference a parenthesis makes. Cheers!