| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping IF command from entering zero or 1 for blank cells
Dear All, I have a panel of data with some blank cells (absent observations).
If I replace the blanks with anything ("""", #NA etc.) and then run the IF command (say, IF(B2361,1,B236)), I get a one where the blank cells used to be. I want the value to remain blank, instead of recording a false 'observation'. Can anyone help? Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Starting and Stopping excel from command line. | Excel Discussion (Misc queries) | |||
| Stopping looped "Find" command | Excel Discussion (Misc queries) | |||
| Stopping blank page printing | Charts and Charting in Excel | |||
| counting from left to right and stopping when blank | Excel Discussion (Misc queries) | |||
| Stopping chart line where 1 of 2 columns of data in calculation is blank | Charts and Charting in Excel | |||
Threaded Mode
