I don't mind typing them all in but if I can just use the range i have
already typed in that would save me some time. How do you hardcode them?
--
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.