Trying to get two equations to then present one of four options.
Have no idea where to start, all four need to sit in the one cell.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
=IF(AND(O34 > O33; Q34 > Q33); Z28;
IF(AND(O34 < O33; Q34 > Q33); Z29;
IF(AND(O34 > O33; Q34 < Q33); Z30;
IF(AND(O34 < O33; Q34 > Q33); Z31; ))))
If you want to include equality add
For inequality use:
AND can be changed to
OR if you need such logic.