How get true response when numbers divisible by 12?

L

lax_fan

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

Alok

=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
conditional formatting?? 3
Conditional Formating to Show Numbers NOT Divisible by another 3
excel conditional formuals 1
getting numbers that are divisible by 4 4
how do an @if formula to meet criteria where x is divisible by 12 2
getting numbers divisible by 4 from random numbers in ascending order 6

Top