| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I stop a formula from executing based on a cell value?
I have a worksheet that gets a date from another worksheet and displays it in
a cell. I want it to only update if another cells value is "Y", If the cells value is "N", I want it to leave the displayed date the way it is and not update the date from the other sheet. I have used an "IF A1=Y(formula)" but it doesn't leave the exsisting date displayed. I don't want to use iterations either because that would affect the other formulas I think. Any suggestions gratefully accepted. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXECUTING A FORMULA | New Users to Excel | |||
| Executing a formula based on criteria being met | Excel Worksheet Functions | |||
| Getting a chart to stop if the formula resutls in a blank cell | Excel Worksheet Functions | |||
| How to stop excel from plotting a "blank" cell with formula as zer | Excel Discussion (Misc queries) | |||
| Executing a macro from a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
