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)))