Diving with Zero and not getting an error

Hi,

I am facing the problem of diving with zero to calculate growth. However, i know that mathematically its not possible, but in case there is a way it'll be a huge help. The data is in the sample document and if anyone could help with it.

When I calculate growth from FY16-17(=(C3-B3)/B3) and FY17-18(=(D3-C3)/C3) , I get #DIV/0!, Whereas I want 0% for FY16-17 growth and 100% growth for FY17-18.

Please help!!!

You can use iferror.

Something like - =IFERROR((C3-B3)/B3,0) in cell E3

Or you could just test B3 and C3 for a zero value

Formula:

Please Login or Register  to view this content.

Since you have replies already from 2 people (now 3...) please specify WHO you are talking to. Is this what you had wanted (based on Post 2)

That's the same reply as post 4. It STILL doesn't say who you are talking to. Please amend your sheet and repost with further examples showing what you DO mean.

Not only do your replies not say who they are addressing, they don't explain what you expect to get. Your question was how not to get an error when you divide by zero. You've had a few responses with different options answering that question.

Explain what you mean by

... should ideally be a growth of certain percentage in cell F3.

What certain percentage? How do you WANT to calculate it?

archimaitreya, this is a duplicate thread and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

You have two threads with the same question and there are people actively posting and you are actively responding. This causes confusion and wasted effort. Please do not do this.