“MOD” function in Excel is used for-
“MOD” function in Excel is used for-
एक्सेल में ”MOD” फंक्शन (फलन)………….. के लिए प्रयोग किया जाता है-
Detailed Solution & Logic
Returning remainder from division/भाग से प्राप्त शेषफल
The MOD() function in Excel returns the remainder after a number is divided by another number.
Syntax:
=MOD(number, divisor)
Example:
=MOD(10, 3) → Result = 1 (because 10 ÷ 3 = 3 remainder 1)
So, MOD is used to find the remainder, not the quotient or modulus conversion.
Similar Practice Questions
If you use the Fill Handle to drag the cell containing ‘Q1’ in MS Excel,
If you use the Fill Handle to drag the cell containing ‘Q1’ in MS Excel,...
In MS Word, which command allows users
In MS Word, which command allows users to duplicate a selected block of text and...
Which one is NOT the method to search
Which one is NOT the method to search for and replace text in Microsoft Word?...
What is the shortcut key to subscript selected words in MS-Word?
What is the shortcut key to subscript selected words in MS-Word? MS – वर्ड में...
In MS Excel 365 which of the following
In MS Excel 365 which of the following is one of the options to edit...
Which of the following methods is the
Which of the following methods is the quickest way to open an existing MS Excel...
What is the difference between dragging
What is the difference between dragging text with the mouse (left-click) and Ctrl + dragging...