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

Try

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Phil H." wrote
in message ...

For data validation I want to allow a blank, or zero through
and
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/m229
View this thread: http://www.hightechtalks.com/t2285047

The validated cell has been formatted percentage. Numbers between 0 an
100 are no longer valid according to the existing formula. With
percentage-formatted cell, what would the formula be to allow the use
to enter whole numbers (0 to 100) and have them become % and thu
return a true condition

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