Hello Mates.
I want write two characters result in another cell,
EX:
A1>> 25*50
B1>>1250
in B1 cell I want to see the result of (25*50) How can I do it?
Thanks.
Hello Mates.
I want write two characters result in another cell,
EX:
A1>> 25*50
B1>>1250
in B1 cell I want to see the result of (25*50) How can I do it?
Thanks.
You will need to use either VBA or use old XLM calls via Names...
Using Names... highlight cell B1 and create a new name as follows:
Name: EVAL
RefersTo: =EVALUATE(A1)
In B1 enter: =EVAL
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks