Complex IF statement using columns containing formulas

Hi Everyone,

Hoping there is a solution for this or a different way I can accomplish it.

I have an IF statement in a column where the False portion is a formula referencing two columns that are formulas. I get #Invalid Operation. I know it's due to the false portion based on testing the conditions in the IF statement and just testing out a simple formula rather than the whole IF statement where I subtracted the two columns and got same error.

The formula I'm using in the column with the error is:

=IF(AND(ISBLANK([Start POI]@row), [Rule Type]@row = "Speed Limit"), ([Speed Limit (km/h) Final]@row - [Speed (km/h)]@row), IF(AND(ISBLANK([Start POI]@row), [Rule Type]@row <> "Speed Limit"), "", [Speed Limit (km/h) Final]@row - [POI Speed Limit]@row))

Any ideas or help would be much appreciated. Thank you!!

Find more posts tagged with

Accepted answers

Mark Cronk

Try:

=IF(AND(ISBLANK([Start POI]@row), [Rule Type]@row = "Speed Limit"), (VALUE([Speed Limit (km/h) Final]@row ) - VALUE([Speed (km/h)]@row)), IF(AND(ISBLANK([Start POI]@row), [Rule Type]@row <> "Speed Limit"), "", value([Speed Limit (km/h) Final]@row) - value([POI Speed Limit]@row)))

Mark

All comments

Mark Cronk

Try:

Mark

alexis.ray89371

That worked! Thank you so much!

Mark Cronk

Glad you found a solution. Thank you for contributing to the Community.

Mark

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.