| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore calculation if text | Excel Worksheet Functions | |||
| Put in text after a calculation | Excel Discussion (Misc queries) | |||
| Calculation within Text | Excel Worksheet Functions | |||
| Concatenate text to make calculation | Excel Discussion (Misc queries) | |||
| Formula Calculation as Text ( no formula ) | Excel Discussion (Misc queries) | |||
Threaded Mode
