Formula for concatenating text with results from calculation
 

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.

Formula for concatenating text with results from calculation
 

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.

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.