C
Charlie C
Hello, I recently created a spreadsheet to track crashes for a
insurance company. With some help I was able to insert a formula t
track percentages based on multiple criteria (i.e. preventable v
non-preventable).
Here is a sample of the formula that is used several times in m
spreadsheet:
==AVERAGE(IF('DataSheet'!$W$8:$W$500='Location, Time & Dat
Analysis'!$AA$154,IF('DataSheet'!$AF$8:$AF$500='Location, Time & Dat
Analysis'!G152,1,0)))
Everything works great excep when there is no information in
particular field I get a #DVI/0! error. I know there are formulas tha
will make this display as a '0' or 'N/A' however I am not sure where t
enter this into my existing formula.
Any help would be greatly appreciated.
Please let me know if I need to provide any additional information
insurance company. With some help I was able to insert a formula t
track percentages based on multiple criteria (i.e. preventable v
non-preventable).
Here is a sample of the formula that is used several times in m
spreadsheet:
==AVERAGE(IF('DataSheet'!$W$8:$W$500='Location, Time & Dat
Analysis'!$AA$154,IF('DataSheet'!$AF$8:$AF$500='Location, Time & Dat
Analysis'!G152,1,0)))
Everything works great excep when there is no information in
particular field I get a #DVI/0! error. I know there are formulas tha
will make this display as a '0' or 'N/A' however I am not sure where t
enter this into my existing formula.
Any help would be greatly appreciated.
Please let me know if I need to provide any additional information