Mar 25 2024 10:13 AM
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.
Mar 25 2024 10:24 AM
SolutionIt 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.
Mar 25 2024 10:41 AM
=IFS(
AND(B7="A", A10="Orange Peel"), V180,
AND(B7="Abaco", A10="Orange Peel"), V143,
AND(B7="Albert", A10="Orange Peel"), V58,
TRUE, 0)
Mar 25 2024 10:42 AM
Mar 25 2024 10:24 AM
SolutionIt 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.