Feb 04, 2022 04:11 AM
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
Solved! Go to Solution.
Feb 04, 2022 04:14 AM
You could just simplify your formula like this:
IF({Revenue Recognised in FY22}+{Year Recognised To Date}={Contract Value},"MATCH","INCORRECT")
Feb 04, 2022 04:14 AM
You could just simplify your formula like this:
IF({Revenue Recognised in FY22}+{Year Recognised To Date}={Contract Value},"MATCH","INCORRECT")
Feb 04, 2022 04:41 AM
Thank you Scott! That’s worked :grinning_face_with_smiling_eyes: