=1*if(And(A1=1,A1<=3),.10,if(And(A1=4,A1<=7),.20 ,if(And(A1=8,A1<=10),.3,0
)))
another possibility might be
=1*if(A1<1,0,if(A1<=3,.1,if(A1<=7,.2,if(A1<=10,.3, 0))))
--
Regards,
Tom Ogilvy
"Ntisch" wrote in
message ...
Hi,
hoping someone can assist with an IF formula I am trying to write.
it goes;
= IF number between 1 & 3, then 1 *10%, IF number between 4 & 7, then 1
*20%, IF number between 8 & 10, then 1 * 30%
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