| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too many IF functions
Hey guys,
I have an IF statement that surpasses the amount of allowed IF's (7). I have looked around and everyone seems to say to do a Vlookup but I don't think that is what I want. Can you help me out? This is the code: ================================================== ====================== =IF(F3="0 to < 4 feet Ditch and No Barrier",4,IF(F4="Concrete Barrier without to < 2 feet Ditch",3,IF(F5="Guide Rail without to < 4 feet Ditch",3,IF(F6="= 4 feet to < 8 feet Ditch",3,IF(F7="Light Duty Netting",3,IF(F8="Concrete Barrier with = 2 Ditch",2,IF(F9="Guide Rail with = 4 feet Ditch",2,IF(F10="Light Duty Fence",2,IF(F11="Heavy Duty Fence",1,IF(F12="Heavy Duty Netting",1,"")))))))))) ================================================== ====================== Thanks, Molly My website: http://techmolly.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
| excel functions and User defined functions | Excel Programming | |||
![Molly[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
