Logical Functions

Hello Ayo

Thank you for your question and welcome to the forum.

If you are new to using these functions, it really is a matter of practicing using them so that you get used to how they work.

Here is a short summary of the functions you mentioned:

1. IF function: used to get Excel to test/evaluate one cell, then based on the outcome of the evaluation (true or false), Excel will then decide between two different alternatives to enter into the cell. The two alternatives may be text, value or formula based.

2. AND function: used to test multiple cells (up to 30) - if each test is evaluated as true, then the outcome of the function is true; otherwise the outcome is false. In other words, all of the tests must be met in order for the outcome to be true.

3. OR function: again used to test multiple cells (up to 30) - if at least one of the tests is evaluated as true, then the outcome of the function is true. If none of the tests are evaluated as true, then the outcome will be false.

4. Combining (nesting) the AND or OR function within an IF function allows Excel to test multiple cells (rather than just a single cell) before it decides the outcome of the evaluation (true or false).

I hope this helps.
Amanda


Kind regards
Amanda