You said you wanted to show blank if the answer is zero.

Your answer apparently is not zero.

Your M9 is either zero or blank, which makes your correct answer be
37.5, not zero.


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=476499