View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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