Multiply cells in single row if cell is not blank

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!!

Find more posts tagged with

Accepted answers

Emily Zeiger

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.