The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

# Re: Nested IF Statements Error

Solved
827 0
cancel
Showing results for
Did you mean:
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
18 - Pluto

You could just simplify your formula like this:

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

2 Replies 2
18 - Pluto

You could just simplify your formula like this:

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

5 - Automation Enthusiast

Thank you Scott! That’s worked :grinning_face_with_smiling_eyes: