Which one?

This formula

=IF(C26,C60/C26-1,0)

is the equivalent of

=IF(C26<0,C60/C26-1,0)

If C26 is not zero C60/C26-1 otherwise 0

The usual way you get a #DIV/0! error is, unsurprisingly, when you try
to divide by zero so this means that the calculation is carried out
except when C26 is zero, in which case a zero is returned.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503708