Ntisch

the formula:

=1*IF(AND(A1=1,A1<=3),0.1,IF(AND(A1=4,A1<=7),0.2 ,IF(AND(A1=8,A1<=10),0.3,0
)))

works for me

If, as Tom suggests, your value lies between the (integer) numbers in the
formula, you will get a zero result. Hence 3.5 is between 3 and 4 so does
not meet any of the criteria.

You might want to try this instead:

=1*IF(A1<=3,0.1,IF(A1<=7,0.2,IF(A1<=10,0.3,0 )))

Regards

Trevor


"Ntisch" wrote in
message ...

Hi Trevor,

thanks for your suggestion.

I am using your formula;

=1*if(And(A1=1,A1<=3),.10,if(And(A1=4,A1<=7),.20 ,if(And(A1=8,A1<=10),.3,0
)))


I am using a cell reference as the constant - the 1 (multiplied by) in
the forumla. I am putting different numbers in the cell that is used as
the constant.

I reinputted the numbers and found that the formula works using some
numbers in the cell reference, but otherwise doesn't work instead
returning a NAME? error.

Puzzled?

thanks


--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile:
http://www.excelforum.com/member.php...fo&userid=5791
View this thread: http://www.excelforum.com/showthread...hreadid=389973