Dont want excel to autofill the values of formula into cell

Hi there,
as the title suggest, I have a problem for which I hope there is an easy fix.

I have one column with a number (L1), and the column next to it with another number (R1). In the row below, I want to automatically calculated the value: L2=L1-R1. Now I drag this formula down along the rows, and get the value of the latest calculation (where there is actually data) in all cells. However, I only want to show the data in the upper rows and not have it repeated until I actually enter the value.

I hope you understand this somewhat complicated description .

Cheers

There's an easier way but off the top of my head try-

=IF(ISERROR(L2-L1),"", L2-L1)

if the data is not available (#REF) it should remain blank until data is available. Is that what you want to do?

Hi,
I solved it via =IF(E51="";"";(F51-E52)). worked perfectly, but thanks for your tip!