Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |