excel formula using IF, need help

Occasional Visitor

Hello all,

 

Though I get all correct but i will like to understand a few formula.

 

 

panadol_1-1585491010478.png

 

 

above is my data that I generated out.

 

on the right side (with the percentage), the formula given was =IF(O7<>0,(O7-N7)/O7,0).

How do i make my 100% to seen as 0%?

 

0 Replies