If statement that takes a column value and if meets a criteria, subtracts a number

I have been trying for several days and could use some help. In the image example here, I need to set 'Final Quote' to be one of the following:

A) If [Apply TCC] is checked, then take [Quote before TCC] value, subtract 200 from it, and put that answer in the [Final Quote]

B) If Apply TCC is not checked, I just need the same value in Quote before TCC in Final Quote wiht no changes

Closest I have gotten is a version of this:

=IF(([Apply TCC]@row=1,"[Quote before TCC]"-200),[Apply TCC]@row=0,"[Quote before TCC]")

If I keep the quotes, it is unparseable, if I remove them, then it throws an error for Scenario A and puts the exact name of the column Quote before TCC in Final Quote.

Please any help would be awesome!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

=IF([Apply TCC]@row = 1, [Quote before TCC]@row - 200, [Quote before TCC]@row)

All comments

Paul Newcome

Try this:

=IF([Apply TCC]@row = 1, [Quote before TCC]@row - 200, [Quote before TCC]@row)

brian25736

Thank you that worked perfectly, I swear I tried that but apparently not, thanks Paul you are the best!

L_123

=IF([Apply TCC]@row=1,[Quote before TCC]@row-200,[Quote before TCC]@row)

*Lol i had this window open in a different tab since this morning, didn't have that paul already helped sorry

Paul Newcome

Happy to help. 👍️

@L_123 I used to do that all the time. Hahaha. I had to get in the habit of only opening something if I was going to work on it right then and refreshing if I had to step away for more than a few minutes.

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.