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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping IF command from entering zero or 1 for blank cells
Try it like this...
=IF(COUNT(B236),IF(B2361,1,B236),"") -- Biff Microsoft Excel MVP "Nick S" <Nick wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping IF command from entering zero or 1 for blank cells
Try
=IF(ISERROR(B236*1),"",MIN(1,B236)) If this post helps click Yes --------------- Jacob Skaria "Nick S" wrote: 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 |
Reply |
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 |