how do you put them together
You missed to tell what should happen if A1=A2
.
Assuming the second condition should read A1>=A2
which is the exact negation of the first condition, this is exactly the situation the IF()
function is provided for. See this help text.
If you actually need to treat the alternative to A1<A2
differently depending on additional conditions (A1=A2
or not e.g.) edit your question and add the needed information.
Also: Please consider to read this thread.
These two formulas:
IF(A1<A2;1;IF(A1>A2;2))
IFS(A1<A2;1;A1>A2;2)
… both let unspecified (first displays FALSE, second - #NA) when A1=A2.
Thank you just what I needed.
Please, if the answer solves the question click .