Microsoft Office Forums - View Single Post - Formula for blank cells

Thread: Formula for blank cells

View Single Post

Old

09-11-2017, 03:59 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

There are multiple ways to do what you ask and here's just one...

=IF(Sheet2!A1<>"",Sheet2!A1,"")

Reply With Quote