Forum Discussion
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")...
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.
=IFS(
AND(B7="A", A10="Orange Peel"), V180,
AND(B7="Abaco", A10="Orange Peel"), V143,
AND(B7="Albert", A10="Orange Peel"), V58,
TRUE, 0)