I used to use this formula all the time. If a cell I was checking was blank then I wanted to return a blank in the cell I was solving for, if the cell I was checking had a value, then I wanted to put something else in. How do I write this formula with the newer versions of excel.
Yes, 2007 is a newer version of excel from my perspective. I've been using excel since the very first version.
I even tried writing the formula as =if(a1>1,b1,"blank") a1 happens to be a date. That didn't even work.
Thank you for your help on this.
Bridget
Bookmarks