Apr 23 2022 11:53 PM
Hi
I'm trying to output the following but I keep getting errors
=IF(A1>B1, "ABOVE", "BELOW", IF(A1=B1, "EQUAL"))
What am I doing wrong?
Thanks
Apr 24 2022 12:03 AM - edited Apr 24 2022 12:08 AM
@cheeseontoast101 That should be:
=IF(A1>B1,"ABOVE",IF(A1<B1,"BELOW","EQUAL"))
or if you want something different
=CHOOSE(SIGN(A1-B1)+2,"Below","Equal","Above")