IFS AND

[galley2]

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.

[#2 · Accepted solution]

@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]

@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)

[#4]

@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. ;)