Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Putting line between formula | Excel Discussion (Misc queries) | |||
putting 2 conditions in a formula | Excel Discussion (Misc queries) | |||
formula for putting points into groups | Excel Worksheet Functions | |||
how can i fix one entire column after putting my formula there so. | Excel Worksheet Functions | |||
Putting numbers in excel without it changing into a formula? | Excel Worksheet Functions |