You probably should use either the CHOOSE function or a VLOOKUP

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"forever" wrote in
message ...

I have set of pre determined formulae. the condition for selecting a
particular formula is the number of characters entered in one
particular cell. In other words, a formula should select from a table
of formula depending upon the characters in the data entry cell.

Have tried IF formula, but does not work since nesting IF formula
limited to 7.

Help Required..


--
forever
------------------------------------------------------------------------
forever's Profile:
http://www.excelforum.com/member.php...o&userid=28526
View this thread: http://www.excelforum.com/showthread...hreadid=482427