Class 16: Advance IF Copy Copy Copy

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 )