Function MOD (Modulo) The MOD function returns the rest of a division. It is very useful in many situations like a test, conditional formatting or data validation