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

brian25736

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!

Paul Newcome

Try this:

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

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.