| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I automatically zero out a cell when another cell changes
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I automatically zero out a cell when another cell changes
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dr_Ray" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Expansion | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| copy combobox - cell link to change automatically | Excel Worksheet Functions | |||
| Edit cell automatically takes you to cell | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
Linear Mode
