IF AND confusion

[deuce]

I only know how to do the simplest IF statements not combo's... need some help to think here.

IF F3 is less than F2 and G2 then "1"

IF F3 is greater than F2 and G2 then "2"



thanks.

 

[hsk]

Try using function AND;
search the excel help for details

=IF(AND(1 < A3,A3 < 100),A3,"Out of Range")

Displays the second number above, if it is between 1 and 100, otherwise displays a message (The value is out of range.)

 

[will_simpson]

What do you want to if its higher than one of the other two cells but lower than the other?

Or do you mean higher or lower than the sum of the other two cells?

 

[Krishnakumar]

Hi,

=IF((F3<F2)*(F3<G2),1,"Something Else")

=IF((F3>F2)*(F3>G2),2,"Something Else")

HTH