How to add text from one formula to the result of another formula
Hello,
I have two formulas.
1) calculates how many validated units there are. The result is 600.
2) calculates how many units there are in total. The result is 1200
I would like these formulas to combine so the result is 600 / 1200
I am aware I can use +" 1200" but this number will keep changing and the total number to update automatically in the combined formula. Is this possible?
Best Answer

You would write it out the same way but you would use the second formula in place of the hardcoded number in quotes.
=formula_1 + " / " + formula_2
Answers

Correction: I am aware I can use +" 1200" but this number will keep changing and I would like the total number to update automatically in the combined formula. Is this possible?

You would write it out the same way but you would use the second formula in place of the hardcoded number in quotes.
=formula_1 + " / " + formula_2

Thanks Paul!! Works perfectly!
Help Article Resources
Categories
Check out the Formula Handbook template!