FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false.

Detailed explanation-2: -The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition.

Detailed explanation-3: -IF is one of logical functions that evaluates a certain condition and returns one value if the condition is TRUE, and another value if the condition is FALSE.

Detailed explanation-4: -Technically, the AND function tests the conditions you specify and returns TRUE if all of the conditions evaluate to TRUE, FALSE otherwise.

Detailed explanation-5: -The AND function in Excel checks if every argument you put in it evaluates to TRUE. If everything evaluates to TRUE, then the function will return TRUE, otherwise, even if only one argument is FALSE, the function will return the value FALSE. This is the sister function to the OR function.