How do I automatically zero out a cell when another cell changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel 2003, I want to automatically zero out a cell where data has already
been entered by a user when a third cell is changed to a prespecified value.
 
Hazarding a guess ..

Perhaps you mean something like this in say,
D1: =IF(A1="Yes",B1*C1,0)

D1 will only compute B1*C1 if A1 contains a "Yes",
otherwise D1 will house a zero
 
You must log in or register to reply here.

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

Displaying zeros in cells 2
Cell Value must be zero 4
Blank Cells vs. Zero Values 2
formula result is zero but zero is not populating in cell 3
automatically link cells with a certain result to another workshee 1
copying input to another cell 3
Changing Cell Color Based on Value 2
Counting blanks as zeros 1

Back
Top