Saturday, March 19, 2022

Mod function

Returns the remainder after number is divided by divisor. The result has the same sign as divisor.

Syntax

MOD(number,divisor)

Number     is the number for which you want to find the remainder.

Divisor     is the number by which you want to divide number.

Remarks

  • If divisor is 0, MOD returns the #DIV/0! error value.

  • The MOD function can be expressed in terms of the INT function:

    MOD(n, d) = n - d*INT(n/d)

Examples

Formula

Description (Result)

=MOD(3, 2)

Remainder of 3/2. (1)

=MOD(-3, 2)

Remainder of -3/2. The sign is the same as divisor. (1)

=MOD(3, -2)

Remainder of 3/-2. The sign is the same as divisor. (-1)

=MOD(-3, -2)

Remainder of -3/-2. The sign is the same as divisor. (-1)

3 comments:

  1. I'm so happy to share this with you that can read / see this now. When I started trading binary and forex a few months ago, I really didn't have the necessary tools to trade and I lost a lot until I met Pablo Martinez who taught me all about market psychology as he managed my account for me. Today I am grateful to him for his great offer and help because it really changed my financial situation with an investment capital of $1500 and now I'm earning around $35,500 - $30,000 profits per week. Here is his WhatsApp no: +44 7520 636249 or his email address: pm7234029@gmail.com
    Https://www.facebook.com/PM-Fast-Trade-104912912155335/

    ReplyDelete
  2. My best friend said I deserve a new car. I told him I was waiting to clean up my bad credit report due to my medically induced bankruptcy in 2016, I have 8 student loans totaling about $37k. Each is about $1K-5K. I didn’t want a high interest rate. He came up with the Idea to contact PINNACLE CREDIT SPECIALIST for help. I told him I’d think about it. A couple of months later, he’s dragging me out and I’m buying a new car. I went to a couple of dealerships in the panhandle Area, but I got rejected due to my low credit score of 640 and unclean credit report. After feeling uneasy and disappointed, I got no other choice than to contact PINNACLE CREDIT SPECIALIST for help. Boom!!! Huge shoutout to PINNACLE CREDIT SPECIALIST for making my experience a simple one. They cleaned up my credit report and gave me an Excellent score of 809 within 6 days. The good NEWS is that I went to the same dealership which was rejected. Now I’ve been approved of the Nissan Pathfinder car. Having a reliable car is something I’ve wanted for so long and now. Congrats to me on my New Car! HUGE thanks to PINNACLE they did it all. You can get them by email: PINNACLECREDITSPECIALIST@GMAIL.COM or Call them on +1 (323) 406 1225. GOODLUCK!!!! 

    ReplyDelete
  3. I can invest my last dollar with only one person and that’s Mike Defi who prove to be the most honest and trustworthy Expert trader. him the best account manager I have ever known or heard of. him has been helping me. I started with just $1000 and now am getting great profits like $11,670 upward. You get to withdraw yourself after 6-7days of trading, no extra commissions.
    If you are really interested, You can contact him via:
    Email: Defimike93@gmail.com

    ReplyDelete