Previous Topic Next Topic

How to display formula in excel?

Solved/Closed
Daniel - Apr 24, 2010 at 05:40 AM
 Daniel - Apr 24, 2010 at 06:47 AM
hi everyone, for example i have A1=H and A2=G, and A3=A1+A2 how do i make A3 show a final result of "H+G",display text instead of calculating the formula?

2 responses

Answer 1 / 2
Blocked Profile
Apr 24, 2010 at 06:40 AM
Dear Sir,

You should write the formula like the below.

=E3+E6

and then press enter to obtain its results. You should insert the cell address.

Thank you.
Answer 2 / 2
Daniel
Apr 24, 2010 at 06:47 AM
i figured it out you need to put =A1&"+"&A2, thanks guys

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses