No :(
with that formula
=IF(C26,C60/C26-1,0)
It depends on the value in C26. If C26 is not zero that is deemed to be
TRUE so the first operation is performed, i.e. C60/C26-1
If C26 is zero that is deemed to be FALSE so 0 is returned.
This way you never divide by zero so you never get a #DIV/0! error
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=503708