answersLogoWhite

0

The MOD function finds a modulus. That is the remainder when you divide one number into another. So if you divide 10 by 3, you would get a remainder of 1. To do that with the MOD function, you enter it as:

=MOD(10,3)

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

How do you reverse a MOD function in excel?

Ctrl Z


How can you use Excel to calculate the remainder of a division question?

By using the =MOD function.


Why is the function in excel that finds the remainders of two numbers called MOD?

It is the short for MODULUS DIVISION which is an operation of division that aims to get the ramainder rather than the whole number.


What is MOD?

The role of the Ministry of Defense, otherwise known as the MOD, is to protect the independence, security, and interests of the country. It is also MOD's role to ensure the armed forces have training, equipment, and support.


How do you find even and odd in Excel?

If you are referring to the Even and Odd functions, you can just start typing then or find them through the Math and Trig functions category. You can use the Insert Function button on the Formula Bar to do that. You can also do it through menus or tabs, depending on the version of Excel you have. To find out if an actual value is odd or even you could use the MOD function, which finds a remainder. If you divide by 2 and the remainder is 1 it is obviously odd, and if it is 0 then it is even. You use the MOD function like this, where the 2 is dividing into the first value, in this case 10: =MOD(10,2) It could also be used with a cell reference, like this, where it is using A15 as an example: =MOD(A15,2)


What is the step function of Microsoft Excel?

There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.


A formula prewritten by excel is called?

Function


In excel 2013 where are the various function categories stored on the Ribbon?

In Excel Where are the various function categories stored on the Ribbon?


Does the uplookvert function in Excel exist?

There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.


What is the function of percentage in micro-soft Excel?

functions of excel


An If function within an if function in Excel is called what?

A nested if.


How does the trig function ACOS work in Excel?

In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000