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 |
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 |
All times are GMT +1. The time now is 06:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com