I'm creating a formula to limit the entry of "S", "H" and numbers between 0-25 (exclussive) in multiple cells. I tried the formula below but not working.
HTML Code:
I'm creating a formula to limit the entry of "S", "H" and numbers between 0-25 (exclussive) in multiple cells. I tried the formula below but not working.
HTML Code:
First select the range and then use this:
=OR(A1="S",A1="H",AND(A1>=0,A1<=24))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks