![](https://d3vm0xy31f4bap.cloudfront.net/wp-content/uploads/2022/03/Untitled-design-1-16.png)
Add Your Doubts: Click Here
Summary: In this class, Sir will teach an advanced IF function that is Multiple IF. You can cell use 64 Himes IF in a single cell.
Formula:
Multiple IF: =IF ( logical test [value of true], If [vature of Fate])
When you have to apply 2 conditions of true you will use ‘Compound IF’
Compound IF(and operator): =IF (and [ logical 1, logical 2], value if true, value if false )
Compound IF(OR operator): =IF (OR [ logical 1, logical 2], value if true, value if false )