Prev: prevent user from deleting a tab prevent running macro from menu
Next: list box controls - text property
From: Ron Rosenfeld on 25 Feb 2010 21:18
On Thu, 25 Feb 2010 12:51:02 -0800, Shawn <Shawn(a)discussions.microsoft.com>
wrote:

>I got the following to do just what I wanted (kicks out less than 0, more
>than 24, and anything that isn't on a quarter unit).
>
>=IF(MOD(L1,0.25)<>0,FALSE,IF(L1<0,FALSE,IF(L1>24,FALSE,TRUE)))
>
>--
>Thanks
>Shawn

Glad to help Shawn.

But adding the 0-24 constraint, this is a bit shorter:

=AND(A1>=0,A1<=24,MOD(A1,0.25)=0)

--ron
First  |  Prev  | 
Pages: 1 2
Prev: prevent user from deleting a tab prevent running macro from menu
Next: list box controls - text property