Add a formatted number to a text string
I'm looking to formulate a cell that has the following statement:
"Our project this month's is $xxx [over / under] budget."
I have a cell that calculates the $ value of the monthly budget. I want to include that number in the text string I drafted above.
So if I have a cell that has $152,345, then I want to have another cell that states...
"Our project this month is $152,345 under budget."
If in the following month, if the calculated value is -$345,679, then I want the following statement:
"Our project this month is -$345,679 over budget."
Anyone know how to that?
Help Article Resources
Check out the Formula Handbook template!