putting a name in a formula

  • Thread starter Thread starter T-bart
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

naming an answer in a formula 1
Help please!!! writing excel formula..... 6
Subtracting minutes in an +IF formula 13
Changing colors of a formula total. 2
fractions in formulas 1
Copy a formula using Vlookup 2
Numbers in a formula! 4
Lookup Exact functions in formula? 4

Back
Top