# Errors in formulas

Posted by Randal Byrd on August 19, 2001 12:31 PM

I created a nested argument to look at a cell in one column and depending on it's value, compare it to a value in another column.

=IF(M2=1,IF(U2>7,1,IF(U2>6,2,IF(U2>5,3,IF(M2&LT;6,4)))),IF(M2=4,IF(U2>7,1,IF(U2>6,2,IF(U2>5,3,IF(U2&LT;6,4)))),IF(M2=2,IF(U2>5,1,IF(U2>3,2,IF(U2>2,3,IF(U2&LT;3,4)))))))

The values in M were previously calculated values which I special saved as "values." The values in U are general values.

The problem I'm having is the argument always results in FALSE values.

BUT, if I retype the value in M, the FALSE changes to 1. (But it's a "false" 1, unless I also retype the value in U, then it becomes a valid argument.)

I've tried reformatting the entire column to make sure all cells are formatted as general. Reformatting to make sure all cells are formatted as NUMBER. Nothing works except to physically go in and RETYPE each value in the two cells.

What can I do to avoid having to retype 3000 cells?

Thanks.

RB

Posted by Aladin Akyurek on August 19, 2001 2:26 PM

Randal,

My guess is that your formula is in error. For example, for values 3, 5, 6 of M2 it will return FALSE, because the way it's designed.

Care to describe what you want to do?