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
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