=if(count(e14,j14,p14)<3,"",e14-j14+p14)

Will make the cell look empty until you have 3 numbers in E14, J14, and P14.

Parkingmang wrote:

I have created a spreadsheet that I fill out daily. Some of the formulae take
information from the row above i.e. in cell E15 the formula is =E14-J14+P14.
This creates the same answer all the way down the column until I enter the
next days stats. Is there any way of hiding the results in the rows beneath
the one you are working on ?

--

Dave Peterson