Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert text into Formula
I have created a nested formulae using sumproduct function for a condition.
The formulae sums up value of a range of cells. Col(A) Col(B) (entered as Text) ROW-1 Condition-1 Nested Formula1 ROW-2 Condition-2 Nested Formula2 ROW-3 Condition-3 Nested Formula3 ROW-4 Condition-4 Nested Formula4 ROW-5 Condition-5 Nested Formula5 If in cell A10 , I choose the condition (using data validation pull down menu condition-1,€¦5)), I must be able see the value in cell B10, USING THE ABOVE TABLE. In short, the formulae entered as text in Colm B should get converted into value . I am working with 50 set of conditions. Any help please. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert text into Formula
Do a Google search for eval in the Excel newsgroups and you will get
hundreds of matches. Basically, you can use Evaluate in VBA to do what you want, so you just need a little user-defined function (often called eval) to enable you to pass your text formula into it. Hope this helps. Pete Ananth wrote: I have created a nested formulae using sumproduct function for a condition. The formulae sums up value of a range of cells. Col(A) Col(B) (entered as Text) ROW-1 Condition-1 Nested Formula1 ROW-2 Condition-2 Nested Formula2 ROW-3 Condition-3 Nested Formula3 ROW-4 Condition-4 Nested Formula4 ROW-5 Condition-5 Nested Formula5 If in cell A10 , I choose the condition (using data validation pull down menu condition-1,...5)), I must be able see the value in cell B10, USING THE ABOVE TABLE. In short, the formulae entered as text in Colm B should get converted into value . I am working with 50 set of conditions. Any help please. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert text into Formula
Thanks very much. It worked. However, is there any way to force relative
change in the cell formulas "Pete_UK" wrote: Do a Google search for eval in the Excel newsgroups and you will get hundreds of matches. Basically, you can use Evaluate in VBA to do what you want, so you just need a little user-defined function (often called eval) to enable you to pass your text formula into it. Hope this helps. Pete Ananth wrote: I have created a nested formulae using sumproduct function for a condition. The formulae sums up value of a range of cells. Col(A) Col(B) (entered as Text) ROW-1 Condition-1 Nested Formula1 ROW-2 Condition-2 Nested Formula2 ROW-3 Condition-3 Nested Formula3 ROW-4 Condition-4 Nested Formula4 ROW-5 Condition-5 Nested Formula5 If in cell A10 , I choose the condition (using data validation pull down menu condition-1,...5)), I must be able see the value in cell B10, USING THE ABOVE TABLE. In short, the formulae entered as text in Colm B should get converted into value . I am working with 50 set of conditions. Any help please. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert text into Formula
Can you supply a bit more detail of what you have at the moment and
what you are trying to do? Pete Ananth wrote: Thanks very much. It worked. However, is there any way to force relative change in the cell formulas "Pete_UK" wrote: Do a Google search for eval in the Excel newsgroups and you will get hundreds of matches. Basically, you can use Evaluate in VBA to do what you want, so you just need a little user-defined function (often called eval) to enable you to pass your text formula into it. Hope this helps. Pete Ananth wrote: I have created a nested formulae using sumproduct function for a condition. The formulae sums up value of a range of cells. Col(A) Col(B) (entered as Text) ROW-1 Condition-1 Nested Formula1 ROW-2 Condition-2 Nested Formula2 ROW-3 Condition-3 Nested Formula3 ROW-4 Condition-4 Nested Formula4 ROW-5 Condition-5 Nested Formula5 If in cell A10 , I choose the condition (using data validation pull down menu condition-1,...5)), I must be able see the value in cell B10, USING THE ABOVE TABLE. In short, the formulae entered as text in Colm B should get converted into value . I am working with 50 set of conditions. Any help please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I ENTER THIS FORMULA TO CONVERT TEXT TO DATE =DATEVALUE(, | Excel Worksheet Functions | |||
formula bar shows a ' before text | Excel Discussion (Misc queries) | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions |