I want to make a cell validated so that a user can only enter a value that is either below -0.1 or above 0.1.
This is not necessary the next but is desirable to set a maximum of 999.99 and -999.99.
Thank you in advance J
I want to make a cell validated so that a user can only enter a value that is either below -0.1 or above 0.1.
This is not necessary the next but is desirable to set a maximum of 999.99 and -999.99.
Thank you in advance J
Re: Validation Below Or Above
Have a look at DATA>>>>Validation...although not sure you'll be able to get both conditions on, but will certainly be able to get the first...otherwise, you would need to use VBA...you'd be able to adapt the code here to suit your purposes, but returning an MSGBOX when the conditions where not met...
Re: Validation Below Or Above
for validation on B4 use this custom formula
=AND(ISNUMBER(B4),OR(AND(B4>=-999,B4<-0.1),AND(B4>0.1,B4<=999)))
Re: Validation Below Or Above
well there you go - was wrong about not being able to use data validation - just didn;t thikn to use a formula...always learning....
Don’t have an account yet? Register yourself now and be a part of our community!