Forum Discussion
Solved
Formula
I am trying to create a formula that looks at only two cells: A1 and A2. If A1 = "A" or "B" or "C" AND (A2="M" then I want the output to be 2, otherwise 0 OR if A2="H" then I want the output ...
=OR(A1={"A","B","C"})*((A2="M")*2+(A2="H")*3)Or if A1 contains nothing but A, B or C:
=(A2="M")*2+(A2="H")*3
=OR(A1={"A","B","C"})*((A2="M")*2+(A2="H")*3)
Or if A1 contains nothing but A, B or C:
=(A2="M")*2+(A2="H")*3
- Thank you, it works perfectly. I don't know what function the " * " character does in the equation, I'll have to look that up.
* is an operator which can be used instead of AND().
+ is an operator which can be used instead of OR().
