Posted to microsoft.public.excel.programming

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Validate to quarter units

On Thu, 25 Feb 2010 12:51:02 -0800, Shawn
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(L124, 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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
quarter	Kent Prokopy[_2_]	Excel Worksheet Functions	4	March 24th 09 01:47 PM
Units Produced / (finish time minus start time)=Units Per Hr	Gary A	Excel Worksheet Functions	1	February 10th 09 01:35 AM
every quarter	Roger Govier	Excel Programming	4	January 16th 07 01:23 AM
every quarter	Bob Phillips	Excel Programming	0	January 15th 07 12:53 PM
units	Mindy	Excel Discussion (Misc queries)	3	April 20th 05 05:13 PM

All times are GMT +1. The time now is 10:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us