Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 16th 06, 09:29 PM posted to microsoft.public.excel.worksheet.functions
MDW MDW is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 117
Default Force Excel To Treat A Cell As Blank

I want to have the false part of an IF statement to return a...null?...value
I guess. I want Excel to treat the cell as if it were blank.

Right now, this is the function I have:

=IF(M4<"",IF(ISERROR(YEAR(N4)),M4,N4),"")

It's the

,""

part that I want to replace with whatever will make the cell appear empty.

TIA.
--
Hmm...they have the Internet on COMPUTERS now!

  #2   Report Post  
Old October 16th 06, 09:42 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 219
Default Force Excel To Treat A Cell As Blank

If a cell is NOT empty [such as having a formula in it], you can't make Excel
think it is empty. You can only make it LOOK empty, which is what you've
done.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"MDW" wrote:

I want to have the false part of an IF statement to return a...null?...value
I guess. I want Excel to treat the cell as if it were blank.

Right now, this is the function I have:

=IF(M4<"",IF(ISERROR(YEAR(N4)),M4,N4),"")

It's the

,""

part that I want to replace with whatever will make the cell appear empty.

TIA.
--
Hmm...they have the Internet on COMPUTERS now!

  #3   Report Post  
Old October 16th 06, 09:44 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 964
Default Force Excel To Treat A Cell As Blank

If a cell contains a formula, then the cell is not blank. Even if the
formula returns nothing, the presence of the formula makes the cell non-blank.

Perhaps if you explained what you are trying to do, an alternative could be
suggested.

HTH,
Elkar


"MDW" wrote:

I want to have the false part of an IF statement to return a...null?...value
I guess. I want Excel to treat the cell as if it were blank.

Right now, this is the function I have:

=IF(M4<"",IF(ISERROR(YEAR(N4)),M4,N4),"")

It's the

,""

part that I want to replace with whatever will make the cell appear empty.

TIA.
--
Hmm...they have the Internet on COMPUTERS now!

  #4   Report Post  
Old October 16th 06, 09:52 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,572
Default Force Excel To Treat A Cell As Blank

The zero length string ( "" or null as you call it), will give a cell the
appearance of being empty (blank), since there is nothing visible displayed
in the cell.

Can I guess that it could be that you're looking for something in relation
to perhaps charting (graphing).

If so, try replacing the "" with NA() which XL does not recognize as a value
to graph.
The cell will however, display the #N/A error.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"MDW" wrote in message
...
I want to have the false part of an IF statement to return
a...null?...value
I guess. I want Excel to treat the cell as if it were blank.

Right now, this is the function I have:

=IF(M4<"",IF(ISERROR(YEAR(N4)),M4,N4),"")

It's the

,""

part that I want to replace with whatever will make the cell appear empty.

TIA.
--
Hmm...they have the Internet on COMPUTERS now!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
force Excel to treat numbers as text GottaRun New Users to Excel 2 March 18th 06 11:11 PM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 02:36 AM
How do I force values in a cell in excel? Phyllis Excel Discussion (Misc queries) 10 February 9th 06 06:31 PM
Instead of a negative number, I'd like to show zero... Dr. Darrell Excel Worksheet Functions 6 December 7th 05 09:21 PM
how do i create a blank cell in excel using a formula Tosh Excel Worksheet Functions 1 November 2nd 04 05:22 PM


All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017