How to add text from one formula to the result of another formula

Sam Swain

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?

Paul Newcome

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

Sam Swain

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?

Paul Newcome

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

Sam Swain

Thanks Paul!! Works perfectly!

Paul Newcome

Happy to help. 👍️