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.

=IF(12 < B37 < 36,C37 = B37,0)


Posted by Tom Urtis on January 16, 2002 11:05 AM

How about placing this formula in C37:

=IF(AND(B37>=12,B37<=36),B37,"")

Tom Urtis

Posted by Mike on January 16, 2002 11:17 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 move to C37,
IF B37 is in range two move to C38,
etc..

Mike

How about placing this formula in C37:

=IF(AND(B37>=12,B37<=36),B37,"")

Tom Urtis


What I need to do simply put is if the value in B37 is between 12 and 36 copy it to C37.

=IF(12 < B37 < 36,C37 = B37,0)

Posted by Tom Urtis on January 16, 2002 11:53 AM

Sorry, I'm still not clear what you want. I don't know what you mean by having the formula in one cell take a value in B37, and depending on what hi-lo range that value falls within, make that value "move to" another cell. You may need VBA for this, but then again maybe I'm totally missing the point.

Any elaboration would help.

Tom U.