How get true response when numbers divisible by 12?

G

Guest

Trying to get true response when the cell (month) is divisible by 12. How do
I do formula?
 
G

Guest

=MOD(A1,12)=0

will return true if the number in A1 is completely divisible by 12

Alok Joshi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i create a divisible formula 3
Sums divisible by 12 2
excel conditional formuals 1
Conditional Formating to Show Numbers NOT Divisible by another 3
how do an @if formula to meet criteria where x is divisible by 12 2
conditional formatting?? 2
getting numbers that are divisible by 4 4
getting numbers divisible by 4 from random numbers in ascending order 6

Top