General discussion

  • Creator
    Topic
  • #2190157

    Excel formula

    Locked

    by hduff ·

    I am trying to write an “if blank” formula in Excel

    I have the following formula working –
    =if(blank(D6),0,E5+D6)

    this checks D6 and if blank, enters 0. If not blank, E5 is added to D6.

    I need to check that D6 and C6 are both blank.

    Any suggestions.

    Thanks

All Comments

  • Author
    Replies
    • #3057799

      Reply To: Excel formula

      by john.a.wills ·

      In reply to Excel formula

      =if(blank(D6) & blank (C6),0,E5 + D6)
      I haven’t tried this but I think it will work.

      • #3070440

        Reply To: Excel formula

        by hduff ·

        In reply to Reply To: Excel formula

        I could not get this formula to work.

        When C6 and D6 are both blank, I want to enter a 0 in E6; if either C6 or D6 have a number, I want the following formula
        E5-C6-D6 in cell E6. Then I want to format the column to NOT DISPLAY 0’s after the last positive entry. This will suppress 0’s for the remaining cells in the column that have not been used to date. If you have an e-mail, I could send you an example.

        Thanks for your effort.

    • #3066111

      Reply To: Excel formula

      by misscrf ·

      In reply to Excel formula

      =if((blank(C6) AND blank(D6)),0,E5+D6)

      ??? or do you mean:

      =if(blank(C6),0,E5+C6)

      =if(blank(D6),0,E5+D6)

    • #3060211

      Reply To: Excel formula

      by bschaettle ·

      In reply to Excel formula

      You need the AND() function to check multiple conditions in an IF(). Try this:

      =IF(AND(ISBLANK(C6),ISBLANK(D6)),0,E5+D6)

    • #3105504

      Reply To: Excel formula

      by gcheris ·

      In reply to Excel formula

      Are you trying do do a check book register type function? It looks like you are trying to accumulate values from ‘C” & “D” columns into the third ‘E’ column. It would help to know a bit more about your project.

    • #3004926

      Excel Formula Reply

      by ontopper ·

      In reply to Excel formula

      =IF(AND(blank(D6),blank(C6)),0,E5+D6).
      Jeff Grant

    • #2940397

      BLANK IN EXCEL

      by ksawaneh ·

      In reply to Excel formula

      hi,
      1. single blank use this formular
      =IF(D6=””,0,E5+D6)
      2. for two blank, that and, use

      =IF(AND(C6=””,D6=””),””,E5+D6)

Viewing 5 reply threads