| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Flase" overwriting value in cell...want to preserve existing valu
Hi all:
I have a formula that checks column A for a "Yes" or "No". If "Yes" I want to leave the value (whole number) in Column B intact (this is where I'm having a problem). If column A has a "No" I want to blank out the value in column B. I place the following formula in cell B1 and drag down to apply to all of the B column: =IF(A1="No"," ") The problem is if column A has a "Yes" it does not retain the value in column B, rather it overwrites it with "False". How can I prevent this from happening? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperion Essbase Excel Add-in - returning text ("0") for null valu | Excel Discussion (Misc queries) | |||
| Hyperlink "friendly-name" won't preserve links in PDF publishing | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| supress/answer "name ... already defined" msg when overwriting w/m | Excel Programming | |||
| Users overwriting cells with Validation set to "Lists" | Excel Discussion (Misc queries) | |||
Threaded Mode
