# AND and OR functions

Adrian, I’m struggling unsuccessfully with the following problem, (not winning)

This has to do with comparing 3 sets of columns and the variable, differing answers.

`UPDATE: see a detailed explanation on the Compare 3 cells in Excel blog post`

The Columns are: S,T,U are being compared to columns X,Y,Z
S is compared to X
T is compared to Y
U is compared to Z

Ideally, if you can figure this out for me please, it would be neat to get the answers, in A same single cell.
If not possible, I quit……

If  S,T,U, are Less than than X,Y,Z,     (answer expressed as “PPP”).
If S>X=”M”, T<Y=”P”, & U<Z=”P”          (answer is expressed as “MPP”)
If  S>X =”M”, T>Y=”M”, & U<Z=”P”        (answer is expressed as “MMP”)

If the S,T,U are GREATER than X,Y,Z,  (answer expressed as “MMM”.
If  S<X=”P”, T<Y=”P”, & U>Z=”M”        (answer is expressed as “PPM”)
If S<X=”P”, T>Y=”M”, & U>Z=”M”        (answer is expressed as “PMM”)
Lastly, if possible, (coz this is number 7, right?) If either OR, X,Y,Z, is greater than S,T,U by greater than 60%, the answer is expressed as= “X”

Is this too much for Excell?
What’s the 2nd best option?
Hope you can help me.

The question is a bit unclear but from what we see you should be using the AND and OR commands. See how to use them on https://www.auditexcel.co.za/AND_OR.html . Hope this helps, otherwise it is better to send a spreadsheet.