IF cell is blank
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. |
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. |
IF cell is blank
=IF(Sheet1!A1="","",Sheet1!A1)
Gord Dibben MS Excel MVP On Fri, 14 Nov 2008 11:40:06 -0800, 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. |
IF cell is blank
Thank you Sean, I realized after writing my question that the first time I
tried that formula I had entered a space between the quotes and got a false. That sent me down the path of confusion and dead ends. Question though. Isn't there something like =IF(a1, value if true, value if false) i.e. if there's anything in A1, anything at all, then the if statement is evaluated as "true"? Thanks, you solved my conundrum, but it's bugging me that I'm not remembering it correctly or confusing two things, or just plain wrong. lol Set me straight!! Thanks again. "Sean Timmons" wrote: =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. |
All times are GMT +1. The time now is 07:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com