How to see calculation and heading in same cell.
 

I would like the cell to perform a calculation and then display the answer as
will as a heading. In other words the answer and the heading will appear in
the same cell.

Perhaps you mean something like ="Heading Name: "&A1+B1
*******************
~Anne Troy

www.OfficeArticles.com


"Jeracho" wrote in message
...
I would like the cell to perform a calculation and then display the answer
as
will as a heading. In other words the answer and the heading will appear
in
the same cell.

You can concatenate text (the heading) and numbers, i.e.,

="Yesterday's date was "&text(today()-1,"Mmmm dd, yyyy")

Just make your calculation the first argument to the TEXT() function


"Jeracho" wrote:

I would like the cell to perform a calculation and then display the answer as
will as a heading. In other words the answer and the heading will appear in
the same cell.