mardi 5 mars 2019

IF statement which only calculates to 2 decimal places

My IF statement:

=IF(AL23*0.2=AM23,"a","r")

Calculates VAT to 3 decimal places so when its checking with AM23 it is returning a false as I only have VAT to 2 decimal places.

How can I make the IF statement only calculate the AL23*0.2 to 2.dps?

Aucun commentaire:

Enregistrer un commentaire