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