| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Troubleshooting my IF formula
My formula below is working perfectly...EXCEPT, I want to add one more IF to
the end, I want to add IF(C17="12x", 6%,""....but it won't let me add this. Am I limited to the number of IF's in one formula? Also - can I use just the number 1, rather than 1x, 2x, 3x...? When I use just the 1, 2 or 3 by itself it gives me a blank. I just can't figure it out - I greately appreciate your help!!!!!!!!!!!!!!!!! =IF(C17="1x",0%,IF(C17="2x",0%,IF(C17="3x",0%,IF(C 17="4x",2%,IF(C17="6x",4%,IF(C17="9x",6%,IF(C17="1 0x",6%,IF(C17="11x",6%,"")))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking portions of a formula | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
