Formulas > =MOD()
How To Use MOD() Function in Google Sheets
Description
How To Actually Use MOD() in Sheets
MOD(dividend, divisor)
Try MOD yourself
In cells B1:B10, use the MOD formula to find the remainder when the values in A1:A10 are divided by 3. The correct answer must display the remainder in the corresponding cell in column B.
Hints (2)
-
Remember to reference the correct cell for the dividend.
-
You need to specify the divisor as 3.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the MOD() formula:
Generate a MOD() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses MOD(). 2 free AI generations, no signup. Members get unlimited use.
Generate a MOD() formula