Use of text and calculation in a formula

  • Thread starter Thread starter Bella
  • Start date Start date
B

Bella

I am trying to create a formula that contains text and calculation of a
percentage. I was able to create the formula but when it gets to give me the
percentage it provides me with a decimal result. Here is the formula

="DAILY AS OF "&MONTH($E$3)&"/"&DAY($E$3)&"/"&YEAR($E$3)&"
"&ROUND(TEXT((E4-E5)/E4,"0%"),100%)&"COMPLETED"

This is what I get when I click enter DAILY FLASH AS OF 3/19/2008 .09
COMPLETED. I want to say DAILY FLASH AS OF 3/19/2008 90% COMPLETED.

Can someone help me!--
Lucrezia Di Vita
 
Try this (in sections for readability):

="DAILY AS OF "&TEXT($E$3,"M/D/YYYY")&" "&
TEXT(ROUND((E4-E5)/E4,1),"0%")&" COMPLETED"

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Maybe this:

="DAILY AS OF "&TEXT($E$3,"m/d/yyyy")&" "
&TEXT(ROUND((E4-E5)/E4,1),"0%")&" COMPLETED"
 
Back
Top