Try:

=C3*LOOKUP(C3,{0,37001,49001,62001},{0.075,0.12,0. 2,0.25})

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Hardy" wrote in message
...
I am trying to create a formula and it is not working the formula i am
trying
to create is

If C3 is < or = 37,500 mulitple by 7.5% if C3 is 37,0001 and < or equal
go
$49,500 = 12% If C3 $49,501 and < or equal to $62,000
=20% If C3 $62,001 and < or equal to $74,500
=25%

Can anyone help? Thanks
--
Ghardy