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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Adding Cells, Get Error. 2
Adding cells until they are greater than a lookup cell and returning a value 1
somewhat complicated conditional formula 2
Formula To Keep Certain Cells Blank 7
Checkbox - Output results to a csv file 4
Repeat formula for all cells in whole column 1
Combining several cells into single equasion? 1

Top