You should be able to use the IF function for this. Something like:
=if(formula=undesired result,"",formula)

If you provide more detail about your formula I should be able to give you a
more specific solution.

"diggers" wrote:

I have created a formula on a timesheet, which I have copied thru to 50
cells, but if there is nothing in one of the cells it copies all of the last
cells number throughout, how do I make this so if the cell is empty, then the
formula cells show as blank, until data is input to the initial cell.
Thankyou