Need Formula

[sajjjid]

In cell A1=((200-100)*1.5)) this is a text.
In cell A2=which formula to sum A1
Thanks.

 

[bobhc]

You say the contents of A1 is text, I am sure there are many who would like to know how you sum text if it is text I suppose you could sum the characters, but as there is no numeric value there is not much to sum.

 

[sajjjid]

How i will edit the title now?

 

[bosco_yip]

Try to use a macro 4 EVALUATE function.

1] A1, enter: (200-100)*1.5

2] Select B1 >> Define Name >>
Name : Calc
Refers to : EVALUATE(A1)
>> OK

3] In B1, enter :

=Calc

4] File shall be saved in Macro-Enabled Worksheet xlsm.

Regards
Bosco

 

[sajjjid]

When i use =calc. It will always refer to A1.
What if D2 or some other.
Thanks.

 

[NARAYANK991]

When i use =calc. It will always refer to A1.
What if D2 or some other.
Thanks.

Hi ,

Because relative addressing has been used , if you enter the formula =Calc in B1 , it will refer to the contents of A1 and evaluate the expression entered in cell A1.

If you enter an expression in cell D2 , and you want it evaluated , enter the formula =Calc in cell E2.

The formula will always evaluate the contents of the cell which is in the same row , and one column to the left of the cell where it is entered.

Narayan

 

[sajjjid]

Yes.
Now i understand.