How do i constrain the results of a formula to display only positive numbers

More specifically, if the result is anything other than a positive number, I don’t want it displayed at all

Posted on Jan 2, 2025 7:52 AM

Reply
1 reply

Jan 3, 2025 8:06 AM in response to LeighMorgan2817

The way you have worded your question you want to retain the formula unchanged and just not display its result if it is not a positive number. If that is your goal, then try a Custom Format something like this:




Select the cell(s) with the formula(s) and in the format panel on the right go to the Cell tab, Data Format and scroll down to the bottom of the dropdown to Create Custom Format...


SG

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do i constrain the results of a formula to display only positive numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.