| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula needed to concatenate text with result from calculation
My info. states FY 2009 budgeted cases are 11,500, a decrease of 495 cases
of actual volume I can concatenate the text and result but can't seem to format the result ="FY 2009 budgeted cases are "& E28& ", a decrease of" &F28& " cases of actual volume" ="FY 2009 budgeted cases are 11500, a decrease of 495 cases of actual volume" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula needed to concatenate text with result from calculation
Maybe this
="FY 2009 budgeted cases are "&TEXT(E28,"#,###")& ", a decrease of " &TEXT(F28,"#,###")& " cases of actual volume or " &TEXT(1-(E28-F28)/E28,"#,##%") Mike "Mgville" wrote: My info. states FY 2009 budgeted cases are 11,500, a decrease of 495 cases of actual volume I can concatenate the text and result but can't seem to format the result ="FY 2009 budgeted cases are "& E28& ", a decrease of" &F28& " cases of actual volume" ="FY 2009 budgeted cases are 11500, a decrease of 495 cases of actual volume" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate text cell and formula cell result | Excel Worksheet Functions | |||
| need result of formula to compare itself to another number andincrease if needed. | Excel Discussion (Misc queries) | |||
| Why does Concatenate formula show but not produce a cell result? | Excel Worksheet Functions | |||
| formula result #value! needs to equal zero for average calculation | Excel Worksheet Functions | |||
| Concatenate text to make calculation | Excel Discussion (Misc queries) | |||
Linear Mode
