If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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
|
|||
|
|||
#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
|
|||
|
|||
#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
|
|||
|
|||
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do you create customised error messages in Access? | Randall | General Discussion | 2 | February 24th, 2006 06:32 PM |
Can I prevent a #DIV/0! error from plotting on a chart | curious | Charts and Charting | 1 | August 26th, 2005 08:35 AM |
Help! I'm getting error messages too much-can't open Resume Wizard | LizLB | General Discussion | 0 | May 3rd, 2005 01:46 AM |
Help, i'm gettiing error: Access has encountered a problem and needs to close... | betsy | General Discussion | 0 | September 14th, 2004 08:20 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |