Thread
:
data validation: formula for validating only multiples of 10
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
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
Reply With Quote
data validation: formula for validating only multiples of 10