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.

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.

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.

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.