View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default keep cell blank if IF statement is False

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
--