Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with if then function
I am trying to use an If function in a spreadsheet to check if a person is
married or single and their taxable income is within a certain range then the tax is calculated. I have pasted the what the formula does but I do not known how to get the formula to work. Can someone help me create the following into an if function? Your help is greatly appreciated. taxman =IF (Cell D2 = Married) and Cell E35 $349,700, then (value in Cell E35 minus $349,700 x 35%) + $94601.00), =IF (Cell D2 = Married) and Cell E35 $195,850 and < $349,700, then (value in Cell E35 minus $195,850 x 33%) +$43,830.50), =IF (Cell D2 = Married) and Cell E35 $128,500 and < $195,850, then (value in Cell E35 minus 128,500 x 28%) + $24,972.50), =IF (Cell D2 = Married) and Cell E35 $128,500 and < $$63,700, then (value in Cell E35 minus $128,500 x 25%) + $8,772.50), =IF (Cell D2 = Married and Cell E35 $63,700 and < $15,650, then (value in Cell E35 minus $63,700 x 15%) + $1,565.00), =IF (Cell D2 = Married and Cell E35 $0 and < $15,650, then (value in Cell E35 x 10%), =IF (Cell D2 = Single and Cell E35 $349,700, then (value in Cell E35 minus $349,700 x 35 %) + $101, 469 .25), =IF (Cell D2 = Single and Cell E35 $160,850 and < $349,700, then (value in Cell E35 minus $160,850 x 33%) + $39,148.75), =IF (Cell D2 = Single and Cell E35 $77,100 and < $160,850, then (value in Cell E35 minus $77,100 x 28%) + $15,698.75), =IF (Cell D2 = Single and Cell E35 $31,850 and < $77,100, then (value in Cell E35 minus $31,850 x 25%) + $4,386.25), =IF (Cell D2 = Single and Cell E35 $7,825.00 and < $31,850, then (value in Cell E35 minus $7,825 x 15%) + $782.50), =IF (Cell D2 = Single and Cell E35 $0 and < $7,825, then (value in Cell E35 x 10%). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |