Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#DVI/0! Error
Hello, I recently created a spreadsheet to track crashes for an insurance company. With some help I was able to insert a formula to track percentages based on multiple criteria (i.e. preventable vs non-preventable).
Here is a sample of the formula that is used several times in my spreadsheet: ==AVERAGE(IF('DataSheet'!$W$8:$W$500='Location, Time & Date Analysis'!$AA$154,IF('DataSheet'!$AF$8:$AF$500='Lo cation, Time & Date Analysis'!G152,1,0))) Everything works great excep when there is no information in a particular field I get a #DVI/0! error. I know there are formulas that will make this display as a '0' or 'N/A' however I am not sure where to enter this into my existing formula. Any help would be greatly appreciated. Please let me know if I need to provide any additional information. |
#2
|
|||
|
|||
Quote:
If you could send a copy of the spreadsheet with sample data in to pubnut999 @gmail.com (but without the 999 ) I will happily take a look and add the formula. Last edited by Spencer101 : April 3rd 12 at 05:27 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Form Err.Raise error not trapped by entry procedure error handler | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |