Formula to find out if a number is divisible by 7 but to 2 decimal places?

[WILLIS28]

Hi,

I can work out if a number is exactly divisible by a number (7 in this instance), but would like to know if it's divisible by 2 decimal places.

Thanks

 

[James006]

Hi,

Could you explain what you mean exactly by " divisible by 2 decimal places " ...

 

[jimrward]

Surely any number can be divisible by 7 to N decimal places

 

[Joe4]

Welcome to the Board!

Can you show us some example of what you mean?
Every whole number when divided by 7 will either have no decimal, or a never-ending decimal.
Or does the number you are dividing by 7 possibly containing decimals, i.e.
dividing 1.4 by 7 would give you 0.2.

 

[WILLIS28]

Thanks all.

As an example I'm using =MOD(A1,7)=0. Ideally, I'd like the 7 to be 7.01, 7.02 etc up to 7.99 and still return a TRUE.

Hope that makes sense.

 

[James006]

Quite difficult to guess the context which is leading you to consider this solution to your problem ... !!!
Mod 7 will generate the remainder of the division of cell A1 by 7 ...
From 0.1 to 0.99 as you are stating it ... means you are extremely close to the next Integer ...

Could you explain the situation you are facing and the complication you need to solve ...?
May be the solution you are anticipating is not precisely the one to consider ....

 

[Joe4]

As an example I'm using =MOD(A1,7)=0. Ideally, I'd like the 7 to be 7.01, 7.02 etc up to 7.99 and still return a TRUE.

What do the numbers in column A look like?
Are they whole numbers or decimal numbers?

If they are whole numbers, it is impossible to have a decimal like .01 or .99.
All the decimal options for whole numbers divided by 7 would be (up to 4 decimals)
0
.1429
.2857
.4286
.5714
.7143
.8571

So I am assuming the numbers in column A might have decimals (or else you wouldn't be asking this question).
See if this does what you want:

=IF(ROUND(MOD(A1,7),1)=0,"TRUE","FALSE")

 

[James006]

Hi,
Quite honestly ... I am very intrigued and curious to know the end of this story !!