IF statement
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: IF statement

  1. #11
    Board Regular
    Join Date
    May 2007
    Location
    North Vancouver, BC, Canada
    Posts
    311
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need help with IF statement

    Toadstool, one more question. When there is NO data in columns E & F, the formula returns FALSE which is not a big deal but I would like it better if it just showed a 0 (zero). To that end, I added IFERROR to the formula (see below) but am still getting the FALSE. Is it possible to have it return a 0 until someone actually uses the worksheet?

    Code:
    =IFERROR(IF(E204:E225<>"",SUM(E204:E225-OFFSET(E204:E225,-1,1))+MAX(F204:F225)),0)

  2. #12
    Board Regular
    Join Date
    May 2007
    Location
    North Vancouver, BC, Canada
    Posts
    311
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need help with IF statement

    Forgot to mention that yes, I did enter the formula as an array formula, using the CTRL+SHIFT+ENTER.

    Code:
    {=IFERROR(IF(E204:E225<>"",SUM(E204:E225-OFFSET(E204:E225,-1,1))+MAX(F204:F225)),0)}

  3. #13
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    219
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Need help with IF statement

    I didn't ELSE the IF statement, which you don't actually need, so:
    {=SUM(E204:E226-OFFSET(E204:E226,-1,1))+MAX(F204:F226)}

  4. #14
    Board Regular
    Join Date
    May 2007
    Location
    North Vancouver, BC, Canada
    Posts
    311
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need help with IF statement

    Perfect! Thank you so much!

    Cheers!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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