Formula & text in one cell
On Nov 16, 10:18 am, samb wrote:
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?
hi samb
the formula would be something like that:
=yourformula & " $ per hour"
for example:
=A1 + B1 * C1 & " $ per hour"
hth
Carlo
|