#DIV/0! Error!!!!!!

[rmeister]

The following Formula is what I am using. I get the result of #DIV/0!
If I want this to return 0 for this error how would I write the
following formula.

=VLOOKUP($A$41,'38 MTD'!$A$3:$E$410,5,FALSE)/VLOOKUP($B$41,'38
MTD'!$A$3:$E$410,5,FALSE)

Thank You In Advance.

 

[Daniel CHEN]

=if(iserror(Your-Formula),0,YourFormula)
--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================

 

[Pete_UK]

You get this error because you are trying to divide by zero. Hence, the
second part of your formula is returning a zero. So, to avoid the
error, you need to check if this returns zero and if so you want some
other value returned. This is how:

=IF(VLOOKUP($B$41,'38
MTD'!$B$3:$E$410,5,FALSE)=0,"zero",VLOOKUP($A$41,'38
MTD'!$A$3:$E$410,5,FALSE)/VLOOKUP($B$41,'38 MTD'!$B$3:$E$410,5,FALSE))

All one formula - replace the "zero" message with one to your liking.

Hope this helps.

Pete

 

[Guest]

=IF(ISERROR(Your_Formula),0,Your_Formula)

=IF(ISERROR(VLOOKUP($A$41,'38 MTD'!$A$3:$E$410,5,FALSE)/VLOOKUP($B$41,'38