dimanche 6 novembre 2016

excel logic error, everything passes the logic test

=IF(D3>0, G2+(D3/111.3), G2-(D3/111.3))

So i'm trying to run this small line of code in excel but for whatever values the result always comes up true on the logic operator. for example let's say d3 is -9, it will run the first equation when really it should run the second. Any ideas?

Aucun commentaire:

Enregistrer un commentaire