Use Excel IF Function to test a condition, if that condition is TRUE then it will return a value which you have specified and if that condition is FALSE it will return another value.
In simple words, you can test a condition and function will a return result with you have specified with TRUE and FALSE respectively for both of the results.
In the below example, we have used a comparison operator to evaluate different conditions.
In the below above example, we have used IF function to create a nesting formula. we have specified a condition and if that condition is false then we have used another if function to evaluate another condition and perform a task and if that condition is FALSE we have used another IF.
This way we have used IF for five times to create a nesting formula. You can use the same for 64 times for a nesting formula.
To learn more about Excel AVERAGE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.