I have the following question relating to the IF Statements: Order of Evaluation, IF statements queue, IF statement logical order in Calc, excel, spreadsheets.
If A1 to A3, contain random numbers e.g. 1,2,3 or, 1,1,1, or 2,2,1 Then, in what logical order can perform then
1) Equality 2) Inequality 3) Greater Than 4) Lower than
According to the following statement:
=IF(AND(Q63=Q64;Q63=Q65;Q64=Q65);"equal";IF(AND(Q63<>Q64;Q63<>Q65;Q64<>Q65);"noID";IF(Q65>Q63;"max";IF(Q65<Q63;"min");"NAN")))
Aucun commentaire:
Enregistrer un commentaire