Menu

Stopping IF command from entering zero or 1 for blank cells

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.worksheet.functions

Joe User[_2_] Joe User[_2_] is offline

Joe User[_2_] is offline

external usenet poster

Posts: 905

Default

Stopping IF command from entering zero or 1 for blank cells

"Nick S" <Nick wrote:
IF(B2361,1,B236))
[....]
I want the value to remain blank, instead of recording
a false 'observation'.

If B236 will only be empty or contain a null string (=''"") or a number,
then try:

=IF(B236="", "", B236)

If you want the result to be no greater than 1, per your original logic (I
wasn't sure if that was intended or a kludge), then try:

=IF(B236="", "", MIN(1,B236))

I have a panel of data with some blank cells (absent observations).
If I replace the blanks with anything ("""", #NA etc.) [....]

If your intent is replace empty cells with text other than the null string
(="""), then try:

=IF(ISNUMBER(B236), B236, "")

----- original message -----

"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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Starting and Stopping excel from command line.	Bruce Edwards	Excel Discussion (Misc queries)	1	April 27th 08 06:34 PM
Stopping looped "Find" command	Varne	Excel Discussion (Misc queries)	3	September 24th 07 09:26 AM
Stopping blank page printing	F*SH	Charts and Charting in Excel	0	July 24th 06 11:39 AM
counting from left to right and stopping when blank	harpscardiff	Excel Discussion (Misc queries)	6	August 19th 05 07:34 PM
Stopping chart line where 1 of 2 columns of data in calculation is blank	Roger B.	Charts and Charting in Excel	2	July 17th 05 07:32 PM

All times are GMT +1. The time now is 09:22 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement