ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   remainder in a division (https://www.excelbanter.com/excel-worksheet-functions/15140-remainder-division.html)

sinbad

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

Nick Hodge

Sinbad

Sure...

=MOD(Number,Divisor)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"sinbad" wrote in message
...
in Excel, is there a function to obtain only the remainder for a division?




Niek Otten

=MOD(Number,Divisor)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"sinbad" wrote in message
...
in Excel, is there a function to obtain only the remainder for a division?





All times are GMT +1. The time now is 05:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com