Formula based on Len
 

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.

Help Required..


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

Formula based on Len
 

You would need to include all sub-formulae in the main formula, liks

=IF(LEN(A1)=1,formula1,IF(LEN(A1)=2,formula2,...

but don't forget you only have 7 nested functions, so you will quickly run
out.

Another way may be to have all the formuale in adjacent cells, say B1, B2,
etc. and use

=CHOOSE(LEN(A1),B1,B2,B3,B4,...)

--

HTH

RP
(remove nothere from the email address if mailing direct)


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

Help Required..


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