The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
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?
