Validation Below Or Above

  • 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...

    D ;)


    :sailboat: [SIZE=1]Better a bad day on the water than a good day in the office[/SIZE]

  • 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....

    D ;)


    :sailboat: [SIZE=1]Better a bad day on the water than a good day in the office[/SIZE]

  • Re: Validation Below Or Above


    Quote from Andy Pope

    for validation on B4 use this custom formula


    =AND(ISNUMBER(B4),OR(AND(B4>=-999,B4<-0.1),AND(B4>0.1,B4<=999)))


    Thank you

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!