1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

when first column of formula is blank

Discussion in 'Ask an Excel Question' started by Kelli Webb, Mar 14, 2019.

  1. Kelli Webb

    Kelli Webb Member

    Messages:
    58
    Hi, in the attached column F should be a calculation of the remaining hours to make up a standard 8hr day or to remain blank until something is entered into the fields in columns C D or E.

    My formula
    appears to be working, except for when columns C and D are blank.

    =IF(C3="","",SUM(8-C3,-D3,-E3))

    Attached Files:

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    12,266
    F3: either
    =IF(LEFT([@Day],1)="S","",8-C3-D3-E3)
    or
    =IF(WEEKDAY([@Date],2)>5,"",8-C3-D3-E3)
  3. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    984
    or change the first part of the IF-statement
    =IF(SUM(Table1[@[Regular Hours]:[Leave]])=0,"",SUM(8-C3,-D3,-E3))
  4. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    709
    If you are going to go with structured references, why not stick to it throughout?
    = IF( SUM(Table1[@[Regular Hours]:[Leave]]),
    8 - SUM(Table1[@[Regular Hours]:[Leave]]), "" )
  5. Kelli Webb

    Kelli Webb Member

    Messages:
    58
    Excellent, thank you to All - I don't know where I would be without you.

    Have a great weekend!

Share This Page