Simple MOD query

[rajivvishwa]

I'm trying to do some conditional formating here.
I've 17R x 5C table.

1) I want to highlight certain cells in first 3 columns that are divisible by 8 and highlight cells last 2 columns that are divisible by 8.8
- I could make the first part work by using formula MOD(A1,8)
- Need help on second. MOD(D1,8.8) seems mathematically incorrect

2) Why is that the answers for 2 formulas below are different?
=MOD((132/8.8),1)
=MOD((15),1)

If I evaluate MOD((132/8.8),1) ; it becomes MOD(15,1) which is 0 but I get -1.77636E-15

[MarvinP]

Hi rajivvishwa and welcome to the forum.

I thought MOD was the remainder after division. So 22 MOD 5 (or Mod(22,5) is 4 with a remainder of 2.

It just doesn't make sense to me to have a decimal divisor like 8.8.

Maybe the alternate formula shown on http://office.microsoft.com/en-us/ex...005209182.aspx will help with this problem.

[martindwilson]

first 3 columns
=AND(A1<>0,MOD(A1,8)=0)
last 2 columns
=AND(D1<>0,ROUND(MOD(D1,8.8),2)=0)