MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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