Allow the NULL() result in a formula to create an effectively empty cell. This posted in the Windows side but not on Mac
There is not way to get a formula result to be the same as an ampty cell.
This explored in much more detail on the Windows Excel side by Jon Peltier.
It would be extremely useful as a statistical 'Missing Value' flag that should propagate through formula as though the cell were empty.