Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF ISBLANK formula (Excel 2003)

    I looked through some old posts to find a way to add to this formula:

    =IF(ISBLANK(L3),(SUM(M3-J3)),"")

    I need to add cell G3 to the ISBLANK statement. I did see a post (#482685) that has a formula that looks for multiple blanks, but could not get it to work for me.

    =IF(ISBLANK(A5);ISBLANK(B5);LEN(B5)=4)

    What am I doing wrong?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF ISBLANK formula (Excel 2003)

    Is this what you want:

    <pre>=IF(AND(ISBLANK(L3),ISBLANK(G3)),"",(SUM(J3:M 3)))
    </pre>


    It is a little hard to figure out what you want from your formula. If that is not what you want, could you try explaining it in words?
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF ISBLANK formula (Excel 2003)

    Thanks Legare!

    I knew there had to be a way to get AND in this formula. I modified yours slightly to get the result that I needed.

    =IF(AND(ISBLANK(L3),ISBLANK(G3)),(SUM(M3-J3)),"")

    Thanks again!

Posting Permissions

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