ExcelBanter - If Statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If Statements (https://www.excelbanter.com/excel-worksheet-functions/7524-if-statements.html)

Penny

If Statements

I'm trying to do an If statement when there's a value in the cell have it
pull another value from a different cell. If no value in the cell have it
come back blank. How would I do that? Would I have to have Is Not Null
somewhere in the If statement?

Frank Kabel

Hi
something like
=IF(A1="","",A1)

--
Regards
Frank Kabel
Frankfurt, Germany

"Penny" schrieb im Newsbeitrag
...
I'm trying to do an If statement when there's a value in the cell
have it
pull another value from a different cell. If no value in the cell
have it
come back blank. How would I do that? Would I have to have Is Not
Null
somewhere in the If statement?

All times are GMT +1. The time now is 10:40 AM.