Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Selecting Formula
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 |
#2
|
|||
|
|||
Selecting Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
dragging a formula | Excel Discussion (Misc queries) | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel |