Excel: variation rate for Vd=0: #DIV/0!
Perrine
-
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
Hello,
does anyone know how to calculate a rate of variation, with
Starting value = 0 and ending value = 2
given that T (%) = (Va-Vd)/Vd * 100
We cannot divide by 0, so Excel shows #DIV/0! in all my cells where Vd = 0
If anyone has encountered this situation before, could you please tell me how to calculate my rate of variation?
Thank you in advance for your attention to this question.
Configuration: Windows XP / Internet Explorer 7.0
does anyone know how to calculate a rate of variation, with
Starting value = 0 and ending value = 2
given that T (%) = (Va-Vd)/Vd * 100
We cannot divide by 0, so Excel shows #DIV/0! in all my cells where Vd = 0
If anyone has encountered this situation before, could you please tell me how to calculate my rate of variation?
Thank you in advance for your attention to this question.
Configuration: Windows XP / Internet Explorer 7.0
