Tag Archives: GSheet help

NOT function

Function Type: Logical Description: NOT function Reverses the logic of its argument.Any FALSE argument will result in TRUE.Any TRUE argument will result in FALSE. Logical test results in a TRUE or FALSE.Logical tests utilize Logical Operators. It can also be used together with IF function where we can assign two different results for when itContinue reading “NOT 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”