Posts by sov82

  • If Function - Cell Not Blank

    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!

  • 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!