Forum Discussion
formula in one shot
A B
=100*40
=40*100
=400*15
=150*70
I have data in A column with EQUAL sign same as shown above and want to calculate in Column B in one shot. so please give solution
3 Replies
Let's say those text formulas are in A2 and down.
Select B2.
On the Formulas tab, click Define Name.
In the Name box, enter Eval
In the 'Refers to' box, enter =EVALUATE(Sheet1!A2) where Sheet1 is the name of the worksheet.
Click OK.
Now, select from B2 down as far as the text formulas in column A go.
Enter the formula =Eval
Press Ctrl+Enter to enter the formulas in all selected cells.
- Dear
Thanks a lot for helping. It is working fine.
One more question I want to ask to you, In excel, there is no formula / function in Formula List, then How you know "Evaluate" function will work here. How can I handle the problems if arises in future and different type of problems???You have to know them. Full list of functions is here Excel-4.0-Macro-Functions-Reference.pdf
