ExcelBanter - using text with a function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - using text with a function (https://www.excelbanter.com/excel-worksheet-functions/8547-using-text-function.html)

J.W.

using text with a function

How do you use text with a simple function in the same cell.
Example:
=B54/4.5 this would show up as 5
I would like it to read:
Total 5, or
5 Total
?? =B54/4.5,"Total" ?? This of course does not work. Any help with this
would be greatly appreciated!
Thanks

R.VENKATARAMAN

type

="total" & " " & B54/4.5

J.W. wrote in message
...
How do you use text with a simple function in the same cell.
Example:
=B54/4.5 this would show up as 5
I would like it to read:
Total 5, or
5 Total
?? =B54/4.5,"Total" ?? This of course does not work. Any help with this
would be greatly appreciated!
Thanks

Nick Hodge

J.W

A formula like this will work

="Total "&B54/4.5

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"J.W." wrote in message
...
How do you use text with a simple function in the same cell.
Example:
=B54/4.5 this would show up as 5
I would like it to read:
Total 5, or
5 Total
?? =B54/4.5,"Total" ?? This of course does not work. Any help with this
would be greatly appreciated!
Thanks

In addition to previous replies, if you want to preserve the format of the
numbers you get you can use the TEXT() function:

="Total " & TEXT(B54/4.5,"0.00")

or

="Total " & TEXT(B54/4.5,"0.0%")

or

="Total " & TEXT(B54/4.5,"#,##0")

etc. etc.

Regards,
KL

"J.W." wrote in message
...
How do you use text with a simple function in the same cell.
Example:
=B54/4.5 this would show up as 5
I would like it to read:
Total 5, or
5 Total
?? =B54/4.5,"Total" ?? This of course does not work. Any help with this
would be greatly appreciated!
Thanks

Aladin Akyurek

You can also custom format the formula cell as:

"Total "0.00

J.W. wrote:
How do you use text with a simple function in the same cell.
Example:
=B54/4.5 this would show up as 5
I would like it to read:
Total 5, or
5 Total
?? =B54/4.5,"Total" ?? This of course does not work. Any help with this
would be greatly appreciated!
Thanks

J.W.

Thank you all, very helpfull and they worked the way I wanted.
Thanks!

"J.W." wrote:

How do you use text with a simple function in the same cell.
Example:
=B54/4.5 this would show up as 5
I would like it to read:
Total 5, or
5 Total
?? =B54/4.5,"Total" ?? This of course does not work. Any help with this
would be greatly appreciated!
Thanks

All times are GMT +1. The time now is 01:42 AM.