Posted to microsoft.public.excel.programming

Phil H.[_5_] Phil H.[_5_] is offline

external usenet poster

Posts: 1

Validation Formula

For data validation I want to allow a blank, or zero through an
including 100. Trying the following formula - the blank part works
but not the 0 - 100. How should this formula be constructed?

=OR(H22="",(AND(H22=0,H22<=100))

--
Phil H
-----------------------------------------------------------------------
Phil H.'s Profile: http://www.hightechtalks.com/m22
View this thread: http://www.hightechtalks.com/t228504

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
validation Formula	RK	Excel Worksheet Functions	4	October 24th 08 05:07 PM
Validation Formula	Teddy-B	Excel Discussion (Misc queries)	7	January 23rd 08 08:53 PM
Validation Formula	Teddy-B	Excel Discussion (Misc queries)	3	December 28th 06 08:19 PM
Validation Formula	cathyds1	Excel Discussion (Misc queries)	5	November 28th 06 06:54 PM
formula validation	jim	Excel Programming	9	April 14th 04 05:55 PM

All times are GMT +1. The time now is 08:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us