DATA VALIDATION

[BRYAN515]

HI, I need help in DATA VALIDATION, I HAVE BEEN TRYING ON MAKE LOGICAL TEST IN DATA VALIDATION TO 

TRUE IF THE RESULT IS TRUE THEN IF NOT GO TO THE NEXT SECTION, I NEED HELP I AM NEW IN EXCEL, LEARNING TO UPGRADE MY BUSINESS THANK YOU

[#2]

Hi @BRYAN515 

It seems you need to use IF function. yet not sure if that what you want.

It would be better if you upload your sheet ,so we can take a look.

here is a simple example for using IF

=IF(A1<100,A1*5%,A1*7%)

 You can use nested if as the following example for the grades 

=IF(C6<70,"F",IF(C6<75,"D",IF(C6<85,"C",IF(C6<95,"B","A"))))