Inequalities Function
"EngAaron" wrote:
I would like a function that will export the following into :
IF B5 = B3 THEN "+"
IF B5<B3, B5B4 THEN " "
IF B5<= B4 THEN "-"
This is the function that I currently have and it does not work:
=IF(B5=B$3,"+",IF(AND(B5B$4,B5<B$3),"",IF(B5<=B$ 4,"-")))
You are over-specifying. Try:
=IF(B5=B$3,"+",IF(B5B$4,"","-"))
In the second test, we do not need AND(B5<$B3,...). That is implied by the
fact that B5=B3 is false.
Similarly, the third test is not needed. That is implied by the fact that
B5B4 is false.
|