On 1 Feb, 18:48,
wrote:
I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

=IF(A1<10000, A1*0.08,IF(A120001, A1*0.04,IF(A110001,A1*0.06)))

And that should do the trick.

Hope this helps,
Matt
http://teachr.blogspot.com