Use of text and calculation in a formula
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 |
Use of text and calculation in a formula
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) "Bella" wrote in message ... 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 |
Use of text and calculation in a formula
Maybe this:
="DAILY AS OF "&TEXT($E$3,"m/d/yyyy")&" " &TEXT(ROUND((E4-E5)/E4,1),"0%")&" COMPLETED" Bella wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 11:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com