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