what is the difference between and and or function in excel?
The difference is that the OR function returns TRUE if at least one if the arguments evaluates to TRUE, and returns FALSE if all arguments are FALSE, whereas in the AND function all arguments must be TRUE to render it TRUE.