Trying to get true response when the cell (month) is divisible by 12. How do I do formula?
L lax_fan May 16, 2005 #1 Trying to get true response when the cell (month) is divisible by 12. How do I do formula?
A Alok May 16, 2005 #2 =MOD(A1,12)=0 will return true if the number in A1 is completely divisible by 12 Alok Joshi
L lax_fan May 16, 2005 #3 Thanks. Worked great. Alok said: =MOD(A1,12)=0 will return true if the number in A1 is completely divisible by 12 Alok Joshi Click to expand...
Thanks. Worked great. Alok said: =MOD(A1,12)=0 will return true if the number in A1 is completely divisible by 12 Alok Joshi Click to expand...
