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 plea...
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???
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