Thread: Validation Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil H.[_5_] Phil H.[_5_] is offline
external usenet poster
  
Posts: 1
Default 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 QuoteReply With Quote