Thread
:
If formula
View Single Post
#
3
Sandy Mann
Posts: n/a
Just for variety
=1*(IF(A17,0.1)+IF(A13,0.1)+IF(A10,0.1))*(A1<11 )
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk
"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
Reply With Quote