Formula for concatenating text with results from calculation
Thank you! Perfect!
"joeu2004" wrote:
On Feb 13, 6:30 am, Mgville wrote:
="FY 2009 budgeted cases are "& E28& ", a decrease of" &F28& "
cases of actual volume" ...this works but I need the numerical
results to have a comma in it.....also I have another one that
needs to look like a percentage.
Use the TEXT function. Examples:
="FY 2009 budgeted cases are " & TEXT(E28,"#,###")
="a decrease of " & TEXT(F28/E27,"#.00%")
HTH.
----- original posting -----
On Feb 13, 6:30 am, Mgville wrote:
Hello, my original looks like
FY 2009 budgeted cases are 11,000, a decrease of 10,881 cases of actual volume
I would like to incorporate the results of the calculated field, in the
right format, into my text statement.
="FY 2009 budgeted cases are "& E28& ", a decrease of" &F28& " cases of
actual volume" ...this works but I need the numerical results to have a comma
in it.....also I have another one that needs to look like a percentage.
|