1. IF

The condition is like→ =IF(cell_number with condition ,”if condition”,”else condition”)

Copy of class Car def init(self, brand, model) self,brand = brand self,model = model (29)_enhanced.png

download (23).png

2. AND

The AND function checks multiple conditions and returns TRUE only if all conditions are true; otherwise, it returns FALSE.

Syntax: =AND(condition1, condition2, ...)

Copy of Copy of Copy of class Car def init(self, brand, model) self.brand = brand self.model = model (9).png

3. OR Function

The OR function also checks multiple conditions but returns TRUE if any one of the conditions is true.

Syntax: =OR(condition1, condition2, ...)

Copy of Copy of Copy of class Car def init(self, brand, model) self.brand = brand self.model = model (10).png

4. Nested IF

A "nested IF" means using multiple IF statements within one another.