For example, I want the formula
“Answer is: “& (A1/B1)
in cell C1 and I want to limit the resulting display in C1 to two decimal places after the text component.
iPad Pro (4th generation)
="Answer is: "& FIXED(A1÷B1,2)
You can also use a custom format, which has the advantage of keeping in the cell a numerical value that can be used in other calculations. If you do that, the formula would simply be = A1/B1.
="Answer is: "& FIXED(A1÷B1,2)
You can also use a custom format, which has the advantage of keeping in the cell a numerical value that can be used in other calculations. If you do that, the formula would simply be = A1/B1.
Thank you - that’s just what I wanted!!
How do I specify number of decimal places for a programmed formula?
