More than 8 calculations from a combo box

B

Bryn

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.
 
B

bpeltzer

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.
 
Top