Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Nested IF Statements Error

Topic Labels: Formulas
Solved
Jump to Solution
1346 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Matt_Engage
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to add a column into my financial forecast that shows whether Column A + Column B = Column C. If the value in Column C doesn’t match I’d like it to show me that it’s incorrect.

The formula I have so far is below but I can’t get around the error. Can anyone tell me what I’m doing wrong?

IF({Revenue Recognised in FY22}+{Year Recognised To Date}={Contract Value},“MATCH”,IF({Revenue Recognised in FY22}+{Year Recognised To Date}>{Contract Value},“INCORRECT”,IF({Revenue Recognised in FY22}+{Year Recognised To Date}<{Contract Value},"INCORRECT”)))

Any advice is appreciated! Thanks

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

You could just simplify your formula like this:

IF({Revenue Recognised in FY22}+{Year Recognised To Date}={Contract Value},"MATCH","INCORRECT")

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

You could just simplify your formula like this:

IF({Revenue Recognised in FY22}+{Year Recognised To Date}={Contract Value},"MATCH","INCORRECT")

Thank you Scott! That’s worked :grinning_face_with_smiling_eyes: