Thanks for your help Tom and Trevor.
The second formula works.
Interestingly the first formula -
=1*if(And(A1=1,A1<=3),.10,if(And(A1=4,A1<=7),.20 ,if(And(A1=8,A1<=10),.3,0
)))
Failed to work even though I wasn't using integers.
regards, Nik
--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile:
http://www.excelforum.com/member.php...fo&userid=5791
View this thread:
http://www.excelforum.com/showthread...hreadid=389973