IF cell is blank
=IF(Sheet1!A1="","",A1)
"John Galt" wrote:
I'm having a brain seizure and can't remember. If a cell on sheet #1 has
someone's name typed in it, I want to display it on sheet#2, if it's blank I
want to display nothing...it's an IF statement with a TRUE / FALSE thing,
yes???
I can't seem to make it work.
|