| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting text within functions
I am interested in a function returning a simple calculation concatenated w/
text, but would like the format of the returned caculation to be a percentage. ie. =concatenate(D2/E2," growth over 07") and want it to return as 135% growth over 07 instead of 1.350323 growth over 07 here is the actual function =IF(H2<1,"need to chase",IF(AND(H21,H2<G2)=TRUE,"08' preseason under forecast",IF(H2<D2,"08' preseason less then 07'",IF(ISERROR(H2/D2)=TRUE,"100%",CONCATENATE(H2/D2," growth over 07'"))))) Any suggestions, Thank you, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OR Functions in a Conditional Formatting Furmula | Excel Worksheet Functions | |||
| Functions and formatting | Excel Discussion (Misc queries) | |||
| combining conditional formatting and functions | Excel Worksheet Functions | |||
| formatting problem with functions | Excel Worksheet Functions | |||
| Formatting in IF Functions | Excel Worksheet Functions | |||
Threaded Mode
