putting a name in a formula

T

T-bart

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
 
R

Rick Rothstein \(MVP - VB\)

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
 
Top