How to see calculation and heading in same cell.

J

Jeracho

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.
 
D

Duke Carey

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
 
Top