View original (French)

What is the opposite of the ISBLANK formula?

Fredo -  
ccm81 Posted messages 11033 Status Member -
Hello,

In column D, I have empty cells and cells with text.

In column H, all the cells are full.

In column I, I would like the values from H to be copied over, but only if there is text in D.

Basically, I need the opposite of the following formula: =IF(ISBLANK(D1),H1)
Does that exist?

Thank you in advance,
Fredo

4 answers

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    The easiest way is to reverse the arguments of your formula:
    instead of =IF(ISBLANK(D1),H1,"")
    you should write =IF(ISBLANK(D1),"",H1) 
    ISBLANK is not a formula, but a function used within a formula.

    --
    Retirement is great! Especially in the Antilles... :-)
    Raymond (INSA, AFPA, CF/R)
    0
  2. EdenGenesisWs Posted messages 25 Status Member
     
    "Text" is a section where one can enter text or not.

    =If ( Not IsEmpty ( Text ) ; "full" ; "empty" )

    In any case, the opposite of "IsEmpty" is "Not IsEmpty"

    “The interest I have in believing something is not proof of the existence of that thing.”
    Voltaire
    -1
    1. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
       
      Be careful with your information: Not IsEmpty is not an Excel function.
      You must be confusing it with the combination =IF(NOT(ISBLANK(cell));"full";"empty")
      0
  3. Fredo
     
    Thank you very much for your replies, the function =IF(ISTEXT(D1),H1,"") works wonderfully, it's exactly what I wanted! :-)

    However, I would like to make this formula a little more elaborate so that the data that should appear in column I is selected under certain criteria:

    For example:

    In column D, I have: Potato, Carrot, Cabbage, Beetroot, and some empty cells.

    I want the content of H to appear in column I, but only if I have "Potato" and "Beetroot" in D.

    Thanks again and have a great weekend!
    -1
  4. ccm81 Posted messages 11033 Status Member 2 434
     
    The content of H should appear only if I have "Potato" and "Beet" in D.
    I think you mean or

    =IF(OR(D1="Potato";D1="Beet");H1;"")

    Regards
    -1