If Function - Cell Not Blank

    Hello All. This looks like a really great site. I am looking for some simple help. My brain hurts today.


    I'd like to do an if statement that only brings in data from a cell if another cell is not blank...


    =if(A1="not blank",A3,"")


    I need help with the "not blank". Sometimes the cell is text, sometimes it is a number.


    Thanks in advance!

    Re: If Function - Cell Not Blank


    That works. I also just flipped the format around...


    =if(A1="","",A2)


    I'm still interested, however, if there is easy way for an IfStatement to only pick up any cell with text.


    eg.


    =if(A1="text",A2,"")


    Thanks for the help!

    Re: If Function - Cell Not Blank


    Sov82

    Quote


    I'm still interested, however, if there is easy way for an If Statement to only pick up any cell with text.


    The ‘IF’ is a test so this is a good way to test, think of if as a question and then think about the result You require, this makes codes easier to write


    jiuk

    Re: If Function - Cell Not Blank




    =IF(NOT(ISBLANK(A1)),A3,"")


    and yes i am a necromancer , wandering and trying to find dead posts

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login