# 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&LT;\$I\$13,I39-\$E\$32,IF(G40&LT;\$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&LT;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&LT;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&LT;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!