mercredi 23 décembre 2015

IF Statements: Order of Evaluation, IF statements queue, IF statement logical order in Calc, excel, spreadsheets

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