Nesting IF/calculate percentage
On Apr 9, 3:14 pm, JN wrote:
Could anyone help me with a formula that would compare Col B & Col C and
return the information in Col D?
Col B Col C Col D
950.91 950.91 0%
0 0 0
0 330.41 100%
1.96 11.05 463.8%
In D1 and copy down:
=if(B1=0, 100%, C1/B1 -1)
Format the cell as Percentage with the desired number of decimal
places.
Not everyone would agree that if B1 is zero, 100% is the right
answer. But that is what you asked for.
|