I want a cell to display the result of a calculation is a date field in the same row if filled in, otherwise I want the cell to display blank. How do I do that in Numbers? Thanks.
MacBook Pro with Retina display, OS X El Capitan (10.11.4)
Something like this?
Please note the European notation (you might adjust to your region).
Paul.
Something like this?
Please note the European notation (you might adjust to your region).
Paul.
Thanks for the reply. The "isblank" test was part of the answer that I ended up embedding in a compound "if".
Conditional display of a cell
