| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF function - limit to the number of IFs?
Is there a limit to the number of IF statements you can have in one function?
i.e. =IF(a1<a10,a10,(IF(a1<a11,a11,(IF(a1<a12,12,(IF(.. ................ and so on. I seem to get to 8 IFs and then get an error. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA "Rnd" Function: Truly Random? | Excel Discussion (Misc queries) | |||
| Function or number depending on input | Excel Worksheet Functions | |||
| Text Function with Different Formatting for Number | Excel Discussion (Misc queries) | |||
| Limit to the number of items in a cell | Excel Worksheet Functions | |||
| How do I limit the number of complete sentences in a spreadsheet c | Excel Worksheet Functions | |||
Threaded Mode
