data validation: formula for validating only multiples of 10
 

need formula for validating data in a cell. function required is for allowing
only multiples of 10

data validation: formula for validating only multiples of 10
 

=MOD(A1,10)=0

HTH
--
AP


"Excelnovice" a écrit dans le
message de news: ...
need formula for validating data in a cell. function required is for
allowing
only multiples of 10

data validation: formula for validating only multiples of 10
 

You can use the custom option on data validation, with a formula like:
=(MOD(A1,10)=0)

Hope this helps,
Miguel.

"Excelnovice" wrote:

need formula for validating data in a cell. function required is for allowing
only multiples of 10

data validation: formula for validating only multiples of 10
 

=MOD(A1,10)=0
"Excelnovice" wrote in message
...
need formula for validating data in a cell. function required is for
allowing
only multiples of 10