I take it that 37,0001 is a typo for 37,501
Also I think you need
If C3 is < or = 37,500 multiply by 7.5% if C3 is (OR EQUAL) 37,501 and <
or equal go $49,500 = 12% If C3 $49,501 (or EQUAL) and < or equal to
$62,000 =20% If C3 (OR EQUAL) $62,001 and < or equal to $74,500 =25%
But what happens when it is $74,500 ?

Some alternatives that you should test:
a)
=IF(C362000,C3*25%,IF(C349500,C3*20%,IF(C337000 ,C3*12%,C3*7.5%)))
b)
=IF(C362000,25%,IF(C349500,20%,IF(C337500,12%,7 .5%)))*C3
c)
(7.5% + 4.5%*(C337500) + 8%*(C349500) + 5%*(C362000))*C3
d)
=HLOOKUP(C3,{0,37501,49501,62001;0.75,0.12,0.2,0.2 5},2,TRUE)*C3
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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