How to Define Between Ranges for If Formula
Posted by Rodney on January 30, 2002 11:20 AM
Does anyone know how to define in between ranges for the IF Formula. For example: i am trying to tell the program to do a subtraction if the number in one cell is between x and y. Does anyone know how this can be done. I would appreciate your help. Thanks. Here's the formula that I am doing by the way.
=IF(G40<$I$13,I39-$E$32,IF(G40<$I$16,I39-$E$39,IF(G40=$I$16,$I$15, $I$15)))
Posted by Steve Hartman on January 30, 2002 11:24 AM
=IF(AND(A1X),do your subtraction here, do something else here)
Posted by Steve Hartman on January 30, 2002 11:26 AM
Let's try again
=IF(AND(A1>x,A1<y),do your subtraction here, do something else here)
Posted by Steve Hartman on January 30, 2002 11:29 AM
One more time
=IF(AND(A1>x,A1<y),do your subtraction here,do something else here)
Posted by Steve Hartman on January 30, 2002 11:30 AM
One more time
=IF(AND(A1>x,A1<y),here,do something else here)
Posted by Mark W. on January 30, 2002 11:30 AM
Steve, leave a space after the < sign [nt]
Posted by Aladin Akyurek on January 30, 2002 11:31 AM
Steve -- Put a space before the less than symbol, whenever you need it. [NT]
Posted by Steve Hartman on January 30, 2002 11:31 AM
last time?
Posted by Steve Hartman on January 30, 2002 11:34 AM
LAST TIME!!!!
Posted by Aladin Akyurek on January 30, 2002 11:35 AM
Are you sure? :)
Posted by Steve Hartman on January 30, 2002 11:38 AM
One way or the other!
