• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Divide by 0

Y

yaelcohen

Member
Hello

It seems very easy question but I can not see the answer

If I have two data of sales:

Sales in 2007 - $100
Sales in 2006 - $0
The growth is 100% but when I put it in Excel, I am getting the error of deviding
by 0 as the formula is: 100-0/0

How should I solve it?

Thanks a lot!
 
You need to do either the post by @bines53 or @bosco_yip have show, you cannot divide by zero, zero is nothing how do you expect to divide by nothing,
In mathematics, division by zero is division where the divisor (denominator) is zero. Such a division can be formally expressed as a/0 where a is the dividend (numerator). In ordinary arithmetic, the expression has no meaning, as there is no number which, multiplied by 0, gives a (assuming a≠0), and so division by zero is undefined. Since any number multiplied by zero is zero, the expression 0/0 also has no defined value; when it is the form of a limit, it is an indeterminate form.
 
Hi David (@bines53 )

You last file LN.xlsx is very useful and helped me a lot to understand your
first reply. I believe it can be added as a function to my research. Thanks a lot!
 
You must log in or register to reply here.
Back
Top