1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel - set zero value for blank cells in IF formula

Discussion in 'Business Applications' started by palmy12, Feb 6, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. palmy12

    palmy12 Thread Starter

    Joined:
    Feb 6, 2013
    Messages:
    4
    I am creating a table where I want to flag if actions are overdue or complete by date and need a formula which will mark overdue if the action is late to be completed e.g.

    cell A1 21/4/13
    cell B2 22/5/13

    My formula in cell C3 reads: =IF(A1>B2"On time","Overdue") which is working fine BUT if I have yet to input a date for C2, D2, E2 etc. it's still marking it as on time - is there a way it will read blank cells without entering an "On time" value. I've tried this but it doesn't work:

    =IF(OR(B2=" ", " "),IF(A1>B2 "Ontime, "Overdue"))
    and also;
    =IF(A1>B2, "On time", "Overdue", " ")

    Hope someone can help!
     
  2. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    Welcome to TSG Palmy, hope you find some help and provide others with help when you can.

    Try this =IF(ISBLANK(B2),"Not Ready",IF(A1>B2,"Ontime", "Overdue"))
     
  3. palmy12

    palmy12 Thread Starter

    Joined:
    Feb 6, 2013
    Messages:
    4
    Thanks Dan - it works, I've been trying to sort that all day too!
     
  4. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    Thats great! Glad to help. Please click the 'Solved' button at the top of the thread.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1088431

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice