As Peo mentioned (Thanks, Peo !),
we could use: =IF(expression, value_if_true , 0) instead
to avoid downstream calc issues.
And to achieve a clean look, if desired, we could switch off
the display of "extraneous" zeros in the sheet via:
Tools Options View tab Uncheck "Zero values" OK
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--