Although the "time of night" - will it be a mistake to suggest this:
=F28*INDEX(C2:C9,MATCH(F28,A2:A9))
Micky


"מיכ�ל (מיקי) �בידן" wrote:

If you don't mind using a simple helper-column - it can be simplified to:
http://img521.imageshack.us/img521/55/nonamenh.png
I did not check many gross incomes - you should do that.
My suggestion eliminates the need to use "Hard-Coding" within the formula.
Micky


והמשך/×™, ×*×�, לקרו×� ×�ת השורה הב×�×”:
***********
×�×� תגובתי עזרה לחץ/×™, ×*×�, על <כן בפס ×”×�ופקי התחתון!
***********
מיכ�ל �בידן
מ×*הל פורו×� "×�ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


"Andmor" wrote:

thanks joe, that seems to have worked bang on!
--
A.


"joemeshuggah" wrote:

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.