+ Reply to Thread
Results 1 to 8 of 8

Struggling with IF and ISBLANK formula

  1. #1
    Registered User
    Join Date
    03-29-2021
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    7

    Struggling with IF and ISBLANK formula

    Hey there I'm struggling with an IF ISBLANK formula. Basically is cell A2 is blank i want B2 to be blank, if A2 has a value, I'd like it to display >= 12 days if 12 or over, or < 12 days if less than 12 days.

    This is the formula I've tried to build, but it doesn't work.
    =IF(ISBLANK(A2), "", if(A2>=12,">= 12 days","< 12 days"))


    Can anyone help?

    Many thanks

    Tim

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,223

    Re: Struggling with IF and ISBLANK formula

    In what way doesn't it work?

  3. #3
    Registered User
    Join Date
    03-29-2021
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    7

    Re: Struggling with IF and ISBLANK formula

    Even when A2 is blank, it's still displaying >= 12 days in B2

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,174

    Re: Struggling with IF and ISBLANK formula

    Don't know if it's the same for GSheets but ISBLANK does not take "blank" cells into account containing a null string (""). COUNTBLANK does ( that is for XL of course)

  5. #5
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    782

    Re: Struggling with IF and ISBLANK formula

    My Gsheet is working fine with that formula. You may change the format to Automatic
    Attached Images Attached Images

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,223

    Re: Struggling with IF and ISBLANK formula

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    03-29-2021
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    7

    Re: Struggling with IF and ISBLANK formula

    Quote Originally Posted by Fluff13 View Post
    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    This worked perfectly - thank you so much

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,223

    Re: Struggling with IF and ISBLANK formula

    You're welcome & thanks for the feedback.

+ 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. I am struggling to understand what this formula is doing?
    By mp3909 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-11-2020, 08:33 AM
  2. [SOLVED] Struggling with Calculation formula Please help!!
    By Pankaj jaswani in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2020, 04:28 AM
  3. [SOLVED] If formula with three criteria struggling
    By Johnny247 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2020, 03:00 PM
  4. Struggling with nested IF formula
    By Raz_M in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-27-2019, 04:28 AM
  5. [SOLVED] Struggling with excel formula
    By olegmcnoleg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-13-2014, 06:37 AM
  6. [SOLVED] Struggling with COUNTIFS formula - help!
    By Joey_997 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2014, 10:54 AM
  7. Help with ISBLANK function referring to a cell with another ISBLANK formula
    By camdameron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-23-2011, 12:45 PM

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