Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

#### Post your problem and you’ll get Expert help in seconds.

Your message must be at least 40 characters
Our professional Expert are available now. Your privacy is guaranteed.

# Excel MOD Function

We can use the Excel MOD function if we want to get the remainder of two numbers after division. While this might seem challenging, this step-by-step guide will enable you use the MOD function to get the remainder of any two numbers after division.

Figure 1: Using the MOD function to get remainder after division

## Generic syntax of the formula

`=MOD (number, divisor)`

Where;

• Number – is the number to be divided
• Divisor – number to divide with

## Understanding the MOD function

This function is fundamental when it comes to getting a remainder after division.

This function is known to return a result in the same sign as the divisor.

In the event that the divisor is zero, then the MOD function will return a #DIV/0! Error.

## Example

Figure 2: MOD function

Step 1: Enter the data in the excel sheet as shown above. Clearly indicate the number and the divisor.

Step 2: In cell D2, put the MOD function, i.e. `=MOD(B2,C2)`

Step 3: Press Enter key

Step 4: Copy the formula across the other cells.

## Other uses of Excel MOD Function

Can be used to extract time from date

Often used in formulas that deal with “every nth” value

## Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

### Did this post not answer your question? Get a solution from connecting with the expert.

Solution examples
I need help with this formula. I need this to include months =INT((M4)/7)&" weeks"&IF(MOD(M4,7)=0,"",", "&INT(MOD(M4,7))&" days") I have the number of Days to Start with
Solved by F. A. in 29 mins
need help with the different sheets and formula IF(A4=B4,0,NETWORKDAYS(A4+1,B4,\$E\$9:\$E\$42) +0.5*(INT((+B4-A4+1)/7)+IF(WEEKDAY(A4+1)+MOD (B4-A4-1,7)>=7,1,0)))
Solved by O. D. in 11 mins
i have this formula currently which works but not if I want it for every day - any ideas ?? (NETWORKDAYS.INTL(L1362,M1362,11,BH!A:A)-1)*("17:30"-"8:30")+IF(NETWORKDAYS.INTL(M1362,M1362,11,BH!A:A),MEDIAN(MOD(M1362,1),"8:30","17:30"),"17:30")-MEDIAN(NETWORKDAYS.INTL(L1362,L1362,11,BH!A:A)*MOD(L1362,1),"8:30","17:30")
Solved by A. D. in 28 mins