Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,118
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ignore calculation if text AndyB Excel Worksheet Functions 4 November 29th 07 03:35 PM
Put in text after a calculation joel Excel Discussion (Misc queries) 2 October 16th 06 08:55 AM
Calculation within Text GeorgeF Excel Worksheet Functions 6 November 18th 05 06:23 PM
Concatenate text to make calculation Fossil_Rock Excel Discussion (Misc queries) 5 August 3rd 05 03:25 PM
Formula Calculation as Text ( no formula ) Nigel Excel Discussion (Misc queries) 2 April 29th 05 02:44 PM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"