vendredi 3 février 2017

Excel. Compare one value with another value in the same column with IF-statement

I want to check in Excel IF one value in one cell is lower in the following cells that comes after that cell. I have 54 rows with values. First I compare value in cell I1 with value in I2 and then I1 with I3 and so on. If I find a value that is lower I want the text to be Check otherwise ok. I have this formula IF(I1

Aucun commentaire:

Enregistrer un commentaire