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
More specifically, if the result is anything other than a positive number, I don’t want it displayed at all
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
How do i constrain the results of a formula to display only positive numbers