| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use if condition more than 7 times in a cell of office 2003
I have a tax rate slab like
Sl. Income Rate 1 1500 or Less Nil 2 1501 to 2000 18 3 2001 to 3000 25 4 3001 to 5000 30 5 5001 to 6000 40 7 6001 to 7000 45 8 7001 to 8000 50 9 8001 to 9000 90 10 9001 to 15000 110 11 15001 to 25000 130 12 25001 to 40000 150 13 40001 to above 200 Now I want to put a formula to calculate the tax of a person. So I have write a formula like =if(a2=1500,"Nil",if(a2<2001,18,if(a2<3001,25,if(a 2<5001,30,if(a2<6001,40,if(a2<7001,45,if(a2<8001,5 0,if(a2<9001,90,if(a2<15001,110,if(a2<25001,130,if (a2<40001,150,200)))))))))))) but problem is that ms excel 2003 not allowed input more than 7 times if condition at a time in a cell. So how could I calculate tax as above of a person, Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
| IF condition using GMT and BST times | Excel Worksheet Functions | |||
| display revised total in Office 2003 when cell data changes | Excel Discussion (Misc queries) | |||
| Upgrading from Office 2003 Small Bus to Office 2003 Pro | Setting up and Configuration of Excel | |||
| Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
Threaded Mode
