Forum Discussion
How to display a percentage value only if greater than zero
What is the correct formula to use if I need the percentage of two different cells to be displayed in a third cell only if the value is greater than zero? And, if the value is less than zero, I need...
Bill_Van That could be:
=(B1/A1-1)*--(B1>A1)where B1 contains the value that should be greater that A1 for the formula to return a percentage other than 0%.