Home

excel formula using IF, need help

%3CLINGO-SUB%20id%3D%22lingo-sub-1262458%22%20slang%3D%22en-US%22%3Eexcel%20formula%20using%20IF%2C%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262458%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThough%20I%20get%20all%20correct%20but%20i%20will%20like%20to%20understand%20a%20few%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22panadol_1-1585491010478.png%22%20style%3D%22width%3A%20609px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180328i04F6E3C5479F3E73%2Fimage-dimensions%2F609x207%3Fv%3D1.0%22%20width%3D%22609%22%20height%3D%22207%22%20title%3D%22panadol_1-1585491010478.png%22%20alt%3D%22panadol_1-1585491010478.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eabove%20is%20my%20data%20that%20I%20generated%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eon%20the%20right%20side%20(with%20the%20percentage)%2C%20the%20formula%20given%20was%26nbsp%3B%3DIF(O7%26lt%3B%26gt%3B0%2C(O7-N7)%2FO7%2C0).%3C%2FP%3E%3CP%3EHow%20do%20i%20make%20my%20100%25%20to%20seen%20as%200%25%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1262458%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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%?