| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
More than 8 calculations from a combo box
Is it possible to do more than 8 calculations form the results of a combo
box. When I have more than 8 items with different values it stops me going higher than 8 when using the "IF" function. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than 8 calculations from a combo box
Post your goal
-- Gary''s Student gsnu200705 "Bryn" wrote: Is it possible to do more than 8 calculations form the results of a combo box. When I have more than 8 items with different values it stops me going higher than 8 when using the "IF" function. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than 8 calculations from a combo box
A formula can contain up to seven levels of nested functions. If you've got
more conditions than that, you're probably better off using lookup or choose. "Bryn" wrote: Is it possible to do more than 8 calculations form the results of a combo box. When I have more than 8 items with different values it stops me going higher than 8 when using the "IF" function. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than 8 calculations from a combo box
Excel 2007 will do more than 8
"Bryn" wrote: Is it possible to do more than 8 calculations form the results of a combo box. When I have more than 8 items with different values it stops me going higher than 8 when using the "IF" function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combo box, List box, Validation | Excel Discussion (Misc queries) | |||
| Macro that can run combo boxes | Excel Discussion (Misc queries) | |||
| Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
| connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
| dynamic combo boxes | Excel Worksheet Functions | |||
Linear Mode
