Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi: I have a cell A1 that displays a taxable income number. Based on that
number, I'd like A2 and A3 to display a tax rate for FED and NC based on the following table... Taxable Income Fed NC 20,000 0.111 0.060 30,000 0.124 0.063 40,000 0.131 0.065 50,000 0.134 0.066 60,000 0.142 0.066 70,000 0.148 0.067 80,000 0.161 0.067 Do I have to use a bunch of if, thens, or is there an easier way. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula calculation | Excel Worksheet Functions | |||
Formula Calculation | New Users to Excel | |||
Calculation formula | Excel Worksheet Functions | |||
formula calculation | Excel Worksheet Functions | |||
calculation in an if formula | Excel Worksheet Functions |