We have already discussed about The IF function, that allows us to make a logical comparison between a value and get the expected result when condition is TRUE or FALSE, but at the same time #IF Functions check only one Logical Condition, but when our result depends on tow or more corresponding result than IF function required another logical condition that check both the criteria and the function available in our Excel #OR and #AND. the both functions are check multiple logic and return the res