if function help

[RVB]

i am dividing 2 cells and using the result
in an if statement. Ex: A1/B1= -2 The result could be a negative
number, not always, but i can't set up an IF function that works if the
number is negative. Ex: -5 to +5 would refer to cell R1 and every number
beyod this range refers to cell S1.
IF(C1<5,R1,IF(C1>=5,S1)). Excel 2002, any reply greatly
appreciated...Bill

 

[CLR]

In Excel2k your formula appears to work as it's written........(if C1 is
less than 5, R1,else if C1>=5,S1)....and returns R1 for any number smaller
than 5, and S1 for 5 and above

This one would do the same thing.......=IF(C1<5,R1,S1)

This one limits the R1 response to the range of -5 to <+5, and gives S1 for
+5 and over and gives blank for anything below -5
=IF(AND(C1<5,C1>=-5),R1,IF(C1>=5,S1,""))

hth
Vaya con Dios,
Chuck, CABGx3

 

[RVB]

Thank you soooo much. I appreciate the quick replys. I used the ABS formula
and you made my day..
Many thanks...
Bill the old snowshoe in the woods in northern VT.