samedi 5 septembre 2015

Simple IF with AND and numeric comparison not resolving correctly

I have the following formula:

=IF(A14>=7 & A14<=18,"I","E")

It resolves to I (true) when A14 is 3 and it should resolve to E (false) as a matter of failing the left if criterium.

I am using LibreOffice Calc on Ubuntu 14.4. What am I doing wrong?

Aucun commentaire:

Enregistrer un commentaire