Formula & text in one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add a label to the numbers in one cell. I want the formula to
calculate the numbers, but then I want it to say "per hour" after the numbers
in the same cell. So, for example, the cell would read "$16.99 per hour"
How can I do this?
 
I am trying to add a label to the numbers in one cell. I want the formula to
calculate the numbers, but then I want it to say "per hour" after the numbers
in the same cell. So, for example, the cell would read "$16.99 per hour"
How can I do this?
Click to expand...

hi samb

the formula would be something like that:
=yourformula & " $ per hour"

for example:
=A1 + B1 * C1 & " $ per hour"

hth

Carlo
 
Hi

Format>cells>Number>Custom> $##.00 "per hour"
Enter your formula in the cell, the result will show $16.99 per hour, but
the cell value will be 16.99 which can be used in further calculations if
required
 
Better, format the cells you want this in as 'Custom' and use this:-
$00.00" per hour"
This way the cell is numeric as opposed to text and can be used in
calculations,
Regards,
Alan.
 
Try also the function "concatenate"

=CONCATENATE (text1,text2,...)
So in your example
=CONCATENATE ("$16.99"," per hour")
If $16.99 is the end result of a calculation in, say, cell B2
=CONCATENATE (B2," per hour")
cheerio
LinLin
 
Back
Top