Remainder Zero Function?
Hello there,
I would like to use a function that will tell me if a number is divisable by another without any remainders. I've had a look at the various functions and can't seem to find a relevant one. If anyone has any ideas that would be great! Thank you in advance Judith |
Hi,
If A1=456,B1=12,then if C1=mod(A1,B1) is zoro,then A1is divisible by B1.If C1 is 6,the remainder will be 6 and that A1 is not divisible by B1. Thank you, K.S.Warrier "JudithJubilee" wrote: Hello there, I would like to use a function that will tell me if a number is divisable by another without any remainders. I've had a look at the various functions and can't seem to find a relevant one. If anyone has any ideas that would be great! Thank you in advance Judith |
Another way
=INT(A1/B1)=A1/B1 -- HTH RP (remove nothere from the email address if mailing direct) "K.S.Warrier" wrote in message ... Hi, If A1=456,B1=12,then if C1=mod(A1,B1) is zoro,then A1is divisible by B1.If C1 is 6,the remainder will be 6 and that A1 is not divisible by B1. Thank you, K.S.Warrier "JudithJubilee" wrote: Hello there, I would like to use a function that will tell me if a number is divisable by another without any remainders. I've had a look at the various functions and can't seem to find a relevant one. If anyone has any ideas that would be great! Thank you in advance Judith |
=MOD(number,divisor)=0
HTH, Bernd |
All times are GMT +1. The time now is 10:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com