Column has a formula, need answer as a multiplier

C Value column is a formula

=IF(ISBLANK([Solution #31 Correction Factor]@row), "", IF([Solution #31 Correction Factor]@row = 9.5, "1.05", IF([Solution #31 Correction Factor]@row = 10, "1", IF([Solution #31 Correction Factor]@row = 10.5, "0.95", IF([Solution #31 Correction Factor]@row = 11, "0.91", IF([Solution #31 Correction Factor]@row = 11.5, "0.87", IF([Solution #31 Correction Factor]@row = 12, "0.83", "Replace Solution")))))))

I need the response, in this case .83, to be multiplied against the Concentration result.

So I need = [Stage 11 62 Concentration]@row * ["C" Value]@row which gives an Invalid Operation.

Help? I am sure there is an easy answer.

Thanks!!

Find more posts tagged with

Formulas

Accepted answers

All comments

Anjanesh Vaidya

Hi Elizabeth Aird,

You can try the below formula in "C" Value column where I have made some syntax changes.

=IF(ISBLANK([Solution #31 Correction Factor]@row), " ", IF([Solution #31 Correction Factor]@row = 9.5, 1.05, IF([Solution #31 Correction Factor]@row = 10, 1, IF([Solution #31 Correction Factor]@row = 10.5, 0.95, IF([Solution #31 Correction Factor]@row = 11, 0.91, IF([Solution #31 Correction Factor]@row = 11.5, 0.87, IF([Solution #31 Correction Factor]@row = 12, 0.83, "Replace Solution")))))))

Thank You!

Anjanesh Vaidya

Elizabeth Aird

That worked.. thank you!!

Elizabeth Aird

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.