For example, I want the number entered to be a multiple of 15. The only numbers the cell will accept will be: 15, 30, 45, 60, 75 etc...
2006-12-01 11:53:42 · 3 answers · asked by fly_girl_pc12 2 in Computers & Internet ➔ Programming & Design
Select your range of cells to validate.
Go to --> Data > Validation
[Allow] = Custom
[Formula] = NOT(MOD(A1,15))
Replace A1 with the first cell of the range you select.
2006-12-01 15:47:50 · answer #1 · answered by Kookiemon 6 · 0⤊ 0⤋
Create a list element with all available values, and set it to only accept those values (assumes you are not having like 1000+ numbers of multiples of 5's). Set the cell up for the list.
Otherwise, you would have to set a cell with:
=if(cell%5=0,showbuttontocontinue,"")
2006-12-02 01:56:34 · answer #2 · answered by Anonymous · 0⤊ 0⤋
you might need to us an "IF...THEN" formula but I'm not sure how to contruct it.
IF (B1)15,30,45,60... is True, THEN....
2006-12-01 19:57:02 · answer #3 · answered by barry-the-aardvark 2 · 0⤊ 0⤋