Re: 'If' Function and empty cells

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: ANB (anonymous_at_discussions.microsoft.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 04:01:06 -0800

I was putting in spaces (" "), so I changed them all to nulls (""). Thanks for that tip, makes sense now. I also used the formula you suggested and that returned the results I was expecting. Could you tell me in words what that formula is doing? I don't understand why the multiplication sign is in the formula? Thanks for your help!
     
     ----- Aladin Akyurek wrote: -----
     
     Using a space (that is, " ") for nothing is not a good idea. If column H
     houses formulas that return a space, make them return "" instead. That said,
     try:
     
     =IF(ISNUMBER(H11)*(H11>B$2), "X", "")
     
     "ANB" <anonymous@discussions.microsoft.com> wrote in message
     news:FE25421C-9B50-48E5-84C8-BC752F7D39C0@microsoft.com...
> Here is what I have:
>> =if(H11>B$2, "X", " ")
>> B2 in this case is equal to 1 and H11 is equal to 2, therefore 2>1 and the
     result is X in the cell.
>> The problem I am having is when I copy that formula down and the value in
     the H column that I am refering to is " " (nothing). For some reason,
     "nothing" is greater than 1 and I get an X in my cell. Does anyone have any
     suggestions? I don't want to change the nothing values to zeros in my H
     column, I would like the cell to appear empty.
>> Thanks.
> ANB
>

Relevant Pages

  • Re: Error Checking Code, Excel 2000 & 2003
    ... Sub ErrorCheckTEST() ... Dim cell as Range, cell1 as Range ... msg= "ERROR Description is empty" ... MsgBox "ERROR Description is empty" ...
    (microsoft.public.excel.programming)
  • Re: Delete Table Rows (Blank) Macro Question
    ... I wish to just delete the empty ... Dim pCell As Word.Cell ... If pCell.RowIndex> pCurrentRow Then ... 'Current cell is not empty? ...
    (microsoft.public.word.vba.general)
  • Re: Error Checking Code, Excel 2000 & 2003
    ... 'checks each cell in row have data or no data next row if all blank end ... MsgBox "ERROR Description is empty" ... MsgBox "ERROR Type is empty" ...
    (microsoft.public.excel.programming)
  • Re: Find First Row where "value" = ""
    ... Then when you need to add a new entry, you just add an entry to the list ... Populating all 65,536 rows is not efficient. ... The next cell then is empty of course. ...
    (microsoft.public.excel.programming)
  • RE: Looping Through Variables
    ... i have always used Empty. ... In reference to clearing values in one instruction, its not the cell values ... Dim anyListEntry As Range ... Dim sourceWS As Worksheet ...
    (microsoft.public.excel.misc)