Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation
Hi Soniya
One way: =OR(MOD(A1,10)=0,MOD(A1,15)=0)*(A1<0) -- Best Regards Leo Heuser MVP Excel Followup to newsgroup only please. "Soniya" skrev i en meddelelse ... Hi all, I have this formula in data validation from an answer to my prev question to allow entry of either muliples of 10 or 15. =OR(MOD(A1,10)=0,MOD(A1,15)=0) Now I would like to prevent 0 also in this range? Ho can I modify the formulae? TIA Soniya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |