remainder in a division

sinbad · Feb 26, 2005

in Excel, is there a function to obtain only the remainder for a division?

Nick Hodge · Feb 26, 2005

Sinbad

Sure...

=MOD(Number,Divisor)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

Niek Otten · Feb 26, 2005

=MOD(Number,Divisor)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Help With Formula for Posting	5	Jun 22, 2013
apostrophe key produces "division sign" in Word 2008 for Mac	0	Jan 15, 2017
Problems created by Recent updates to Outlook 365	0	Jul 24, 2020
Change Form's Recordsource with SQL Statement?	0	Mar 25, 2015
how do i create a divisible formula	3	Jan 6, 2010
Using a cell's value to copy another cells info to another workshe	1	Mar 16, 2010
Allocating remainders	2	Oct 16, 2008
Remainder Zero Function?	3	Nov 9, 2004

Ask a Question