+ Reply to Thread
Results 1 to 6 of 6

Old formula =if(a1=' blank','blank ',b1) doesn't work anymore

  1. #1
    Registered User
    Join Date
    05-01-2017
    Location
    Boulder, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    3

    Old formula =if(a1=' blank','blank ',b1) doesn't work anymore

    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

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Old formula =if(a1=' blank','blank ',b1) doesn't work anymore

    The formula should be the same. I am going to guess that in cell A1, there might be a space (aka " "). Try to select cell A1 then hit "Delete" key and see if your formula return the correct result.

  3. #3
    Forum Contributor
    Join Date
    01-13-2006
    Location
    Texas
    Posts
    161

    Re: Old formula =if(a1=' blank','blank ',b1) doesn't work anymore

    I think you should try "" as a blank cell unless I am reading your post incorrectly.

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,908

    Re: Old formula =if(a1=' blank','blank ',b1) doesn't work anymore

    Try:

    =IF(AND(A1>=1,ISNUMBER(A1)),B1,"blank")

  5. #5
    Registered User
    Join Date
    05-01-2017
    Location
    Boulder, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Old formula =if(a1=' blank','blank ',b1) doesn't work anymore

    Thank you. I ended up using both @if(A1=" "," ", B1) and @if(A2<0," ",B1) to get it to work. Making the first cell truly blank made all of the difference.
    Thank You!
    Now if I can figure out how to report that it's been solved, I'll be in business.

    Bridget

  6. #6
    Registered User
    Join Date
    05-01-2017
    Location
    Boulder, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Old formula =if(a1=' blank','blank ',b1) doesn't work anymore

    Thank you too Phuocam, I'll try your =IF(AND(A1>=1,ISNUMBER(A1)),B1,"blank") too for fun. Thank you. Why the AND though?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. A VBA code within a XLSM file doesn´t work anymore after replacing a cell range
    By andre_teprom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2016, 08:56 AM
  2. VBA code doesn't work anymore (WinHttpReq)
    By chrisignm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2015, 05:36 PM
  3. Checbox doesn't work anymore
    By daanlachmeijer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2014, 09:30 AM
  4. macro doesn't work anymore
    By cat3appr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2014, 05:31 AM
  5. Replies: 6
    Last Post: 08-14-2013, 01:24 AM
  6. Script doesn't work anymore (auto hide rows and columns
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2013, 02:17 AM
  7. Excel 2007 : Paste special doesn't work anymore
    By eva000 in forum Excel General
    Replies: 2
    Last Post: 03-23-2012, 09:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1