+ Reply to Thread
Results 1 to 2 of 2

Thread: Multiple IFs in a statement is confusing.

  1. #1
    Valued Forum Contributor
    Join Date
    06-30-2008
    Location
    PSL, FL
    Posts
    221

    Multiple IFs in a statement is confusing.

    I got an if statement that says this

    =IFERROR(IF(Q3="","",IF(Q3<0,Q3*(('MLB OVERALL'!$O$2*'MLB OVERALL'!$D$3)+$A$3+I3+O3)/-100,
    (('MLB OVERALL'!$O$2*'MLB OVERALL'!$D$3)+'Week 1a'!$A$3+I3+O3)/$Q3*100)), "")

    However the part I am concerned about is this

    +$A$3+I3+O3

    What I need is this to be added someway I will write it and see what you guys think

    if J3="P" then do not add I3 and if P3="P" then do not add O3.

    so in this example in row 10

    if
    J10=L
    P10=P

    then it would be


    +$A$3+I3

    Any help would be greatly appreciated

    Matt

  2. #2
    Forum Guru
    Join Date
    10-28-2008
    Location
    Not here anymore
    MS-Off Ver
    irrelevant
    Posts
    10,151

    Re: Multiple IFs in a statement is confusing.

    Just concentrating on this part

    +$A$3+I3+O3

    Add the conditions like this:

    +$A$3+if(j3="P",0,I3)+if(p3="P",0,O3)

    cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0