MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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!