It worked fine for me for integers entered in A1. A number like 3.5 would
be excluded and return zero in accordance with the criteria you posted (or
implied in the criteria you posted).
--
Regards,
Tom Ogilvy
"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