Percentage Formula Issue
=IF(ROUND((((B6-B5) /B5) * 100), 0) < 0, "0%", ROUND((((B6-B5) /B5) * 100),
0) & " %")
August B5 = 0 0% (Because there is no July entry)
September B6 = 1 100%
October B7 = 0 0% (Because we are not in October yet)
I want to show the % Increase
|