Download the feature file here https://excels-if-function.com/2020/02/20/nested-if-statement/
This video demonstrates how to write a nested IF statement or IF ELSE function. A nested IF statement is useful if you want to return one of three results (or more).
The video also looks at the nested IF alternative which is the IFS function. The IFS function does not require any nesting and is probably the way to go in more recent incarnations of Excel.
This video will be useful to you if you are asking the following questions:
How do you write an if statement with 3 conditions or more?
What is a nested IF function?
How do I use the IFS function in Excel?
What is the alternative to the IFS function in Excel?
How do I write an if else function?
------------------------