Work as an Excel Expert at GotIt’s ExcelChat

Do you want to make money using your expertise with Excel or Google Sheets?

OR function

Function Type: Logical Description: OR function returns TRUE even if only one of its arguments are TRUE.Any TRUE argument will result in TRUE.Like AND function, this is most commonly used with IF function which also needs logical tests. ![Logical Operators](https://images.ecency.com/DQmWE24KzTxSyR53bzDAZeUTeDt5Xxoremtdgsuc65wMTMG/image.png “Logical Operators”) Logical test results in a TRUE or FALSE.Logical tests utilize Logical Operators. ThenContinue reading “OR function”

AND function

Function Type: Logical Description: AND function returns TRUE if all of its arguments are TRUE.1 FALSE argument will result in FALSE.This is most commonly used with IF function which also needs logical tests. ![Logical Operators](https://images.ecency.com/DQmWE24KzTxSyR53bzDAZeUTeDt5Xxoremtdgsuc65wMTMG/image.png “Logical Operators”) Logical test results in a TRUE or FALSE.Logical tests utilize Logical Operators. Then we can assign two differentContinue reading “AND function”