Conditional Formatting???

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Acceptable multipliers are 1 thru 12 ... Is there a
simpler way to write this other than ...

or(a1,a1*2,a1*3,a1*4,a1*5 etc etc)

Thanks ... Kha
 
Ken,

I'm not sure what you're trying to accomplish, or what your question is, but
perhaps the following formula will work:
=QUOTIENT(A1,12)=A1/12
 
Back
Top