Oct 14 2022 08:49 AM
Hello,
I was wondering if you are able to do an IFS and AND statement in the same cell.
I was able to do an =IF(AND) statement, but would like to do multiple in the same cell and from what I understand it would need to be an =IFS instead of just =IF.
For example, I am able to do the following:
=IF(AND(D4=J5,E4="No"),K5,F4*L5)
However, I want to do multiple of these and change the "J5" to "J4" or "J3" etc. Is this possible or is there a better way to do this?
Any help is greatly appreciated!
-Hin Hin
Oct 14 2022 09:37 AM
SolutionOct 17 2022 08:14 AM
Oct 14 2022 09:37 AM
Solution