Mod (short for Modulus) is a useful Excel function that gives the remainder
after performing a division calculation.
So ‘=Mod(10,3)’ (without the quote marks) gives the answer 1, which is the
remainder after dividing 10 by 3. The Int function can be seen as a counterpart
to Mod because it returns only the whole number result of a division and ignores
the remainder, so ‘=Int(10,3)’ gives the answer 3.
Int and Mod are often used together, as in the example shown, where numbers
of weeks can be converted into years and weeks instead of the decimal fraction
of a year displayed in column B.
Leek Wootton, United Kingdom | Warwickshire Police
IT Business Analyst - Leek Wootton, Warwickshire - £29,112 - £31,491 PA - 37 hrs per week Everyone who works for Warwickshire Police helps to protect our communities from harm. Work with us and ... more >
ICT Project Officer - Guildhall, London EC2 18-month fixed-term contract Bring your project management expertise to one of the country's most prestigious institutions. The City of London is the local authority for the Square Mile, ... more >
EDS are currently looking to recruit a Change, Risk and Issue Analyst to join our Project Management Defence team in Swindon, Wiltshire. Summary: The Regional Operations Cell Analyst will work as part of a small ... more >
London, United Kingdom | Feltham City Learning Centre
ICT Systems Administrator - Feltham City Learning Centre - £23,097 - £24,528 A full time ICT Systems Administrator to work in the Feltham City Learning Centre. This role requires a broad range of ICT skills ... more >More job opportunities
Print
Discuss
Send to friend
RSS feeds
del.icio.us
Digg this
reddit!
