AND FORMULA

It is an Excel AND FUNCTION is a logical function used to necessitate more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in G6 is greater than 200 and less than 400, use =AND(G6>200,G6<400).It ‘s AND function could be used as the logical test inside the IF function to avoid extra nested IFs, and can be combined with the OR function.

Note 1. :- 

It is use to test multiple conditions with AND FUNCTION is use TRUE if all arguments evaluate TRUE/ FALSE if not.

Note 2. :-

 It is an Excel AND function is use to apply more than one condition at the same time, up to 255 conditions. Each logical condition (logical1, logical2, etc.) must return TRUE or FALSE, or be arrays or positions that contain logical values.

Syntax:- =AND (logical1, [logical2], ...)  Enter

Example Step:-

Step 1.) logical1 – It is first condition or logical value to evaluate.

Step 2.) logical2 – {optional} it is second condition or logical value to evaluate.

👉IF/AND FUNCTION :- 

It is an Excel IF/ AND FUNCTION you could insert the AND function inside the the IF function. It is using the above example, you can supply AND as the logical test for the IF function like:-

Example :- =IF(AND(G4>200,G4<400), "Pass", "Fail") ENTER