my validation criterias for the cell are:
input must be divisble to 4 and larger than 100
I can only use = Mod(A1, 4)=0 , but not able to set the 2nd criteria in one
cell.
Would anyone know the way to fulfill both?
thx!
my validation criterias for the cell are:
input must be divisble to 4 and larger than 100
I can only use = Mod(A1, 4)=0 , but not able to set the 2nd criteria in one
cell.
Would anyone know the way to fulfill both?
thx!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks