Formula for concatenating text with results from calculation

  • Thread starter Thread starter Mgville
  • Start date Start date
M

Mgville

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.
 
="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.
Click to expand...

Use the TEXT function. Examples:

="FY 2009 budgeted cases are " & TEXT(E28,"#,###")

="a decrease of " & TEXT(F28/E27,"#.00%")

HTH.


----- original posting -----
 
Thank you! Perfect!

joeu2004 said:
Use the TEXT function. Examples:

="FY 2009 budgeted cases are " & TEXT(E28,"#,###")

="a decrease of " & TEXT(F28/E27,"#.00%")

HTH.


----- original posting -----
Click to expand...
 
Back
Top