ExcelBanter - How get true response when numbers divisible by 12?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How get true response when numbers divisible by 12? (https://www.excelbanter.com/excel-worksheet-functions/26389-how-get-true-response-when-numbers-divisible-12-a.html)

lax_fan

How get true response when numbers divisible by 12?

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

Alok

=MOD(A1,12)=0

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

Alok Joshi

"lax_fan" wrote:

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

lax_fan

Thanks. Worked great.

"Alok" wrote:

=MOD(A1,12)=0

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

Alok Joshi

"lax_fan" wrote:

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

All times are GMT +1. The time now is 09:21 PM.