I think you could shorten
=IF(AND(D5=0,D5<=37106),D5*0.7985,IF(AND(D5=3710 6.01,D5<=40970),D5*0.7585,IF(AND(D5=40970.01,D5<= 65345),D5*0.6885,IF(AND(D5=65345.01,D5<=74214),D5 *0.6702,IF(AND(D5=74214.01,D5<=76986),D5*0.6461,I F(AND(D5=76986.01,D5<=81941),D5*0.6059,IF(AND(D5 =81941.01,D5<=127021),D5*0.5659,IF(D5=127021.01,D 5*0.5359,""))))))))
to
=IF(D5<0,"",D5*IF(D5<=37106,79.85%,IF(D5<=40970,75 .85%,IF(D5<=65345,68.85%,IF(D5<=74214,67.02%,IF(D5 <=76986,64.61%,IF(D5<=81941,60.59%,IF(D5<=127021,5 6.59%,53.59%))))))))
--
David Biddulph

"joemeshuggah" wrote in message
...
try this...be sure to test...
=IF(AND(D5=0,D5<=37106),D5*0.7985,IF(AND(D5=3710 6.01,D5<=40970),D5*0.7585,IF(AND(D5=40970.01,D5<= 65345),D5*0.6885,IF(AND(D5=65345.01,D5<=74214),D5 *0.6702,IF(AND(D5=74214.01,D5<=76986),D5*0.6461,I F(AND(D5=76986.01,D5<=81941),D5*0.6059,IF(AND(D5 =81941.01,D5<=127021),D5*0.5659,IF(D5=127021.01,D 5*0.5359,""))))))))

"Andmor" wrote:

Joe I have tried your formula however once I add in the next set of data
I
get the message that says "you've entered too many arguments for this
function"
--
A.


"joemeshuggah" wrote:

you could use an if statement...

=IF(AND(D5=0,D5<=37106),0.7985,IF(AND(D5=37106.0 1,D5<=40970),0.7585,IF(AND(D5=40970.01,D5<=65345) ,0.6885,"")))....and
so on

you could also use cell references instead of hardcoding the ranges...

"Andmor" wrote:

I am trying to find out net income. in D5 I have the gross income and
in G5
is where the net pay should be listed. The following are the various
tax
brackets along with the percentage it needs to be multiplied against
to give
net pay. I can't figure out what formula to use.

0.00 37,106.00 79.85
37,106.01 40,970.00 75.85
40,970.01 65,345.00 68.85
65,345.01 74,214.00 67.02
74,214.01 76,986.00 64.61
76,986.01 81,941.00 60.59
81,941.01 127,021.00 56.59
127,021.01 53.59

--
A.