#DIV/0! error
On Jan 8, 2:47*pm, "Niek Otten" wrote:
=IF(ISERROR(YourFormula),0,YourFormula)
Or, better,
=IF(YourDenominator=0,0,YourNumerator/YourDenominator)
The OP neglected to say what version of Excel he/she is using. Isn't
there another (better?) way in Excel 2007 to handle errors that avoids
having to duplicate the calculation of yourFormula or yourDenominator?
|