IF statement help

Contributor

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

1 Reply

@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")