dimanche 15 mars 2020

Excell IF statement not returning the correct value

I have the following expression where I'm trying to change the value of a cell using whatever value another cell has.

=CONCAT(IF(F2 < 3; 0; IF(OR(F2 > 3; F2 < 8); 45; 90)); "€")

What I don't understand is, if I choose a value of 9 in F2, it doesn't change the value to 90 has it should.

Aucun commentaire:

Enregistrer un commentaire