PDA

View Full Version : Percentage Difference for Two Percentage



r_know
03-02-2014, 02:32 PM
Hi to All,

I have figures 32.26%, 64.29% and difference between in percentage by formula TEXT(J23/J22-1,"0.00%") is 99.29 %.

But I have two figures, they are 0%, 35.71% and difference between in percentage by formula TEXT(K23/K22-1,"0.00%") is DIV/0!

I would like to tell these two figures are sales performance in Jan and Feb month in percentage.

How to handle if I want difference for percentage when ZERO PERCENTAGE in data range?

Thanks

RL

ashleyuk1984
03-02-2014, 02:56 PM
Maybe you are looking for something like this:


=IFERROR(SUM(J23-J22/J23,"100.00%")

OR


=IFERROR(SUM(J23-J22/J23,J23)

Depending on what you want the answer to be.