How do I leave formula cells blank until corresponding cells are entered?

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

i.e.

A1: B1/C1

If C1 is not entered, the computer assumes it is zero and
provides an error since I am dividing by zero

Is there a way to not calculate the value until B1 and C1
are completed?
 
Back
Top