Forum Discussion

galley2's avatar
galley2
Copper Contributor
Mar 25, 2024
Solved

IFS AND

I am trying to create and IFS AND statement where 2 statements must be true to pull the result from another cell.

 

IFS

(AND(B7="A", A10="Orange Peel"), V180),

(AND(B7="Abaco", A10="Orange Peel"), V143),

(AND(B7="Albert", A10="Orange Peel"), V58),

TRUE, 0)

 

with several more lines similar to the above.  I know I must have something wrong; however; I'm not sure what the fix is.  Thanks for any help - it is appreciated.

 

 

  • galley2 

    It looks like a problem with the your parenthesis. The one after V180 causes it to be the end of the IFS statement, so the subsequent ANDs are outside of the IFS function. 

    If that doesn't help, then please add more description about what is happening when you try your formula.

3 Replies

  • galley2 

    =IFS(

      AND(B7="A", A10="Orange Peel"), V180,

      AND(B7="Abaco", A10="Orange Peel"), V143,

      AND(B7="Albert", A10="Orange Peel"), V58,

      TRUE, 0)

  • galley2 

    It looks like a problem with the your parenthesis. The one after V180 causes it to be the end of the IFS statement, so the subsequent ANDs are outside of the IFS function. 

    If that doesn't help, then please add more description about what is happening when you try your formula.

    • galley2's avatar
      galley2
      Copper Contributor
      Steve_SumProductCom
      Thank you so much. That helped and I found that I forgot to select the item in A10 - that fixed it. It is a Monday I guess. 😉

Resources