functions that allow text and formula

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

Guest

Is there a function that will allows text and a formulas to be in the same cell? For example: susielh's commission this month is: D1*D2

All the example in the same cell showing the calculation?
 
One way

="susielh's commission this month is: "&TEXT(D1*D2,"$#,##0.00")

assuming you use dollar as currency

--

Regards,

Peo Sjoblom

susielh said:
Is there a function that will allows text and a formulas to be in the same
Click to expand...
cell? For example: susielh's commission this month is: D1*D2
 
Hi SusieH!

Peo's answer is correct. But in terms of functions the answer is that
CONCATENATE allows both text and formulas:

=CONCATENATE("Susieh's commission this month is ",D1*D2)

I think that use is pretty rare; same as with SQRT and POWER.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I agree that Peo's answer is correct, but since the OP asked to show the
calculation, the answer will be even better with something like :

="susielh's commission this month is: " & TEXT(D1,"$#,##0.00") & " * " &
TEXT(D2,"$#,##0.00") & " = " &TEXT(D1*D2,"$#,##0.00"), whereby in one of the
first two TEXT functions the format probably has to be changed since is is
likely to be just a number rather then a dollar amount.


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top