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 )
