If

IF function is used to test a single criterion whereas the AND function is used to test multiple criteria. In case that or on con…