C colmcg Board Regular Joined Jul 2, 2004 Messages 101 Nov 27, 2005 #1 Can anyone tell me how I can apply Data Validation to a cell to allow only a number EXACTLY divisable by 5 to be entered. Thanks in advance.
Can anyone tell me how I can apply Data Validation to a cell to allow only a number EXACTLY divisable by 5 to be entered. Thanks in advance.
ACommandLineKindaGuy Active Member Joined May 11, 2002 Messages 304 Nov 27, 2005 #2 If you're validating cell A1, =Mod(A1,5)=0 Or maybe, =Int(A1/5)*5=A1
C colmcg Board Regular Joined Jul 2, 2004 Messages 101 Nov 27, 2005 #3 Thanks, both of your suggestions work equally well. Now I'm spoilt for choice.