Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
=MOD(number,divisor)=0
HTH, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions | |||
need to save values from a function before it changes | Excel Worksheet Functions |