Ntisch

Are you putting the number in cell A1 ? If so, is it in the range 1 to 10 ?
Is the value numeric ? Could the cell have been formatted as text before
you put a value in it ? Try formatting the cell as General and then
re-inputting your number. Otherwise, no, no idea.

Regards

Trevor


"Ntisch" wrote in
message ...

Hi Tom - i am trying to use yr formula below but am getting a zero
result

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

any ideas why?

thanks, Nik


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