Help with CONCATENATE

  • Thread starter Thread starter rcavaliere
  • Start date Start date
R

rcavaliere

I'm hoping someone out there can help me. I am trying to CONCATENATE
couple of statements with a formatted value contained within.

Here is the formula:

=CONCATENATE("Lease this system for as little as: ",(G85), " pe
month")

Here is the Formula for G85: =SUM(G84*0.0316)

where G84 is a Sum Statement

The end result I am looking for is:

"Lease this system for as little as $XX.XX per month"

I hope this makes sense!!! Any help would be greatly appreciated.

Thanks in advance, Ra
 
One way:

="Lease this system for as little as: " & TEXT(G85,"$0.00") & " per
month"
 
Hi

try
=CONCATENATE("Lease this system for as little as: ",Text(G85,"$##.#0"), "
per month")

Regards
JulieD
 
Back
Top