Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Putting line between formula Killer Excel Discussion (Misc queries) 4 June 13th 07 05:09 AM
putting 2 conditions in a formula judgejulz Excel Discussion (Misc queries) 2 December 19th 06 03:56 PM
formula for putting points into groups grime Excel Worksheet Functions 0 October 13th 05 01:47 PM
how can i fix one entire column after putting my formula there so. Hozefa Excel Worksheet Functions 3 April 28th 05 10:21 PM
Putting numbers in excel without it changing into a formula? RachaelDPT Excel Worksheet Functions 3 April 22nd 05 10:12 AM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"