DATA VALIDATION

%3CLINGO-SUB%20id%3D%22lingo-sub-1983166%22%20slang%3D%22en-US%22%3EDATA%20VALIDATION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1983166%22%20slang%3D%22en-US%22%3E%3CP%3EHI%2C%20I%20need%20help%20in%20DATA%20VALIDATION%2C%20I%20HAVE%20BEEN%20TRYING%20ON%20MAKE%20LOGICAL%20TEST%20IN%20DATA%20VALIDATION%20TO%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETRUE%20IF%20THE%20RESULT%20IS%20TRUE%20THEN%20IF%20NOT%20GO%20TO%20THE%20NEXT%20SECTION%2C%20I%20NEED%20HELP%20I%20AM%20NEW%20IN%20EXCEL%2C%20LEARNING%20TO%20UPGRADE%20MY%20BUSINESS%20THANK%20YOU%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1983166%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

1 Reply

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"))))