Posts by will_dearborn

Re: If Function - Cell Not Blank

Quote from sov82;227516

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!

Display More

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

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