Tag Archive: INT

Articles sur le thème : INT

Function MOD (Modulo)

The MOD function returns the rest of a division. This function is very useful for a logical test the conditional formatting data validation Presentation of the MOD function If you divide 12 by 3, the result is 4. The result is a whole number, so the rest of the division is obviously 0. And this …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/function-mod-modulo/

Split Time and Date

If you have in a cell a time and a date (like the use of the function NOW) it’s easy to split them in 2 different cells. Split the date Let’s start from the following document where you have in column A data with date and time We want to split The date in column …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/split-time-and-date/