Say we start with =A1+A2
We want the answer to look clear until BOTH A1 and A2 are entered. Use this
type of form:

=IF(OR(A1="",A2=""),"",A1+A2)

--
Gary''s Student - gsnu200817


"Dave" wrote:

How do I stop cells with no data entered, from showing the formulas as it
looks untidy. Can I have the cells clear until I input the figures?
Many thanks,
Dave