IF formula

tom_bryant

Hi

I'm trying to use an IF formula to return a TRUE or FALSE value if the value in column 1 (called Apr) is greater than the value in column 2 (called 2021 Actual) but struggling to do this.

=IF(Apr@row > [2021 Actual]@row, ''true'', ''false'')

Any help appreciated!

Tom

Andrée Starå

Hi @tom_bryant

I hope you're well and safe!

What happens?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

tom_bryant

Hi @Andrée Starå

I have shared this with you now with a comment.

Thanks in advance!

Andrée Starå

@tom_bryant

Excellent!

Glad we got it working!

There seems to have been a strange character, but now it's working.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!