Inequalities Function

[EngAaron]

All,

I am trying to create an If THEN statement in excel for inequalities.

B3 = 80
B4 = 60
B5 = Cell Value

I would like a function that will export the following into :

IF B5 >= B3 THEN "+"
IF B5<B3, B5>B4 THEN " "
IF B5<= B4 THEN "-"

This is the function that I currently have and it does not work:

=IF(B5>=B$3,”+”,IF(AND(B5>B$4,B5<B$3),””,IF(B5<=B$4,”-“)))

Can someone please help me out?

Thank you very much

 

[Claus Busch]

Hi,

Am Fri, 15 Feb 2013 12:51:03 +0000 schrieb EngAaron:

B3 = 80
B4 = 60
B5 = Cell Value

I would like a function that will export the following into :

IF B5 >= B3 THEN "+"
IF B5<B3, B5>B4 THEN " "
IF B5<= B4 THEN "-"

try:
=IF(B5>=B3,"+",IF(AND(B5<B3,B5>B4),"",IF(B5<=B4,"-","")))


Regards
Claus Busch

 

[EngAaron]

I figured it out...

The function to acheive this in excel is:

=IF(B5>=B3,"+",IF(B5<=B4,"-",IF(AND(B5<B3,B5>B4),"n","n"))

 

[joeu2004]

I would like a function that will export the following into :
IF B5 >= B3 THEN "+"
IF B5<B3, B5>B4 THEN " "
IF B5<= B4 THEN "-"
This is the function that I currently have and it does not work:
=IF(B5>=B$3,"+",IF(AND(B5>B$4,B5<B$3),"",IF(B5<=B$4,"-")))

You are over-specifying. Try:

=IF(B5>=B$3,"+",IF(B5>B$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
B5>B4 is false.