Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0! Error!!!!!!
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. -- rmeister ------------------------------------------------------------------------ rmeister's Profile: http://www.excelforum.com/member.php...o&userid=30163 View this thread: http://www.excelforum.com/showthread...hreadid=544750 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0! Error!!!!!!
=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 ================================= "rmeister" wrote in message ... 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. -- rmeister ------------------------------------------------------------------------ rmeister's Profile: http://www.excelforum.com/member.php...o&userid=30163 View this thread: http://www.excelforum.com/showthread...hreadid=544750 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0! Error!!!!!!
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0! Error!!!!!!
=IF(ISERROR(Your_Formula),0,Your_Formula)
=IF(ISERROR(VLOOKUP($A$41,'38 MTD'!$A$3:$E$410,5,FALSE)/VLOOKUP($B$41,'38 MTD'!$A$3:$E$410,5,FALSE),0,VLOOKUP($A$41,'38 MTD'!$A$3:$E$410,5,FALSE)/VLOOKUP($B$41,'38 MTD'!$A$3:$E$410,5,FALSE)) -- Kevin Backmann "rmeister" wrote: 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. -- rmeister ------------------------------------------------------------------------ rmeister's Profile: http://www.excelforum.com/member.php...o&userid=30163 View this thread: http://www.excelforum.com/showthread...hreadid=544750 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide #div/0 Error When Averaging | Excel Worksheet Functions | |||
Can I prevent a #DIV/0! error from plotting on a chart | Charts and Charting in Excel | |||
Avoiding the dreaded #div/0 error | Excel Worksheet Functions | |||
ERROR | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |