View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Daniel CHEN
 
Posts: n/a
Default #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