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?

Position calculation formula in excel
Number to words in excel formula - Guide
Date formula in excel dd/mm/yyyy - Guide
Percentage formula in excel marksheet - Guide
Vat calculation excel - Guide
Calculation is incomplete. recalculate before saving - Guide

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Student position formula

Similar discussions

Subscribe To Our Newsletter!