ExcelBanter - Need text after formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need text after formula (https://www.excelbanter.com/excel-discussion-misc-queries/173439-need-text-after-formula.html)

Need text after formula

Would like to have statement read, Expenses are [A]% of total income. [A] is
calculated in formula as follows: ="Expenses are "
&(ROUND((N253*100)/N65,2))---How do I complete this to include "% of total
income" Appreciate the help. Thanks! CJ

FSt1

Need text after formula

hi
="Expenses are " & ROUND((N353*100)/N65,2) & " %of the total income"

regards
FSt1

"CJ" wrote:

Would like to have statement read, Expenses are [A]% of total income. [A] is
calculated in formula as follows: ="Expenses are "
&(ROUND((N253*100)/N65,2))---How do I complete this to include "% of total
income" Appreciate the help. Thanks! CJ

CLR

Need text after formula

="Expenses are " & (ROUND((N253*100)/N65,2)) & "% of total income"

Vaya con Dios,
Chuck, CABGx3

"CJ" wrote:

Would like to have statement read, Expenses are [A]% of total income. [A] is
calculated in formula as follows: ="Expenses are "
&(ROUND((N253*100)/N65,2))---How do I complete this to include "% of total
income" Appreciate the help. Thanks! CJ

All times are GMT +1. The time now is 12:32 PM.