IF data is in range copy to different cell
Posted by Mike on January 16, 2002 10:13 AM
What I need to do simply put is if the value in B37 is between 12 and 36 copy it to C37. This is the formula I tried.
=IF(12 < B37 < 36,C37 = B37,0)
Posted by Aladin Akyurek on January 16, 2002 10:29 AM
What follows must be entered in C37
=IF(AND(B37>12,B37<36),B37,0)
Is this what you are looking for?
Aladin
Posted by Mike on January 16, 2002 11:21 AM
I should have asked the question more direct. I will be nesting 6 IF statements in one cell. I need the formula to:
IF B37 is in range one copy B37 to C37,
IF B37 is in range two copy B37 to C38,
etc..
Mike
Posted by Aladin Akyurek on January 16, 2002 11:37 AM
Mike --
What is the full set of "range" criteria/conditions? And, can you afford an empty row before row 37?
Aladin
