Calculate the % between two cells without #DIV/01! Error

[Coldone]

Hi Guys
I want to calculate the % difference of two cells, my formula =(E3-B3)/B3 Works fine to give me the % in cell I3, except, when the cells E3 and B3 are empty I have a #DIV/0! in cell I3.
I have played around with =IFERROR Formula, but I just can't get it to work, I just want Cell I3 to be empty if there is nothing in cells E3 and B3, the sheet looks so untidy with a whole bunch of #DIV/0! running down a column.
If somebody could just show me the correct formula to get this to work I would be grateful.
Thanks In advance
Dodge

 

[coulombevin]

Hi Coldone,

As shown in microsoft manual page (IFERROR function - Microsoft Support), the IFERROR contain two option, the value and the value to return if there is an error. In your case, the division is the "value" and the value to return when there is an error is empty "".

Here's the corrected equations:

=IFERROR((E3-B3)/B3,"")

Bests regards,

Vincent

 

[Coldone]

Thanks Vincent just tried this and works great thanks for the help.
Cheers

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Calculate % between two cells without the #DIV/0! in empty cell.
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Coldone]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Calculate % between two cells without the #DIV/0! in empty cell.
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Sorry guys I didn't know this wasn't allowed.
Cheers