putting a name in a formula
 

if I want to add two numbers and would like a name included with the answer
how do I write the formula? eg. =sum6+9 this would = 15 and I would like to
label it 15hrs. I can't seem to be able to add the hrs to the answer

putting a name in a formula
 

Read a book on elementary Excel. The answer is =SUM(6+9)&"hrs".

Tyro

"T-bart" wrote in message
...
if I want to add two numbers and would like a name included with the
answer
how do I write the formula? eg. =sum6+9 this would = 15 and I would like
to
label it 15hrs. I can't seem to be able to add the hrs to the answer

putting a name in a formula
 

I think you want this (SUM is not need for adding a small number of values
together)...

=(6+9)&"hrs"

although I am guessing you would use cell references in place of those two
numerical constants. By the way, if you were going to sum up a large number
of cells, then you would use the SUM function....

=SUM(A1:A40)&"hrs"

Rick


"T-bart" wrote in message
...
if I want to add two numbers and would like a name included with the
answer
how do I write the formula? eg. =sum6+9 this would = 15 and I would like
to
label it 15hrs. I can't seem to be able to add the hrs to the answer