Posts by sov82

    Re: If Function - Cell Not Blank

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


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



    Thanks for the help!

    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!