98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested IF function
Nested IF function
Resolved · Medium Priority · Version 2007
Tue 15 Sep 2009, 16:28Delegate William said...
William has attended:
Excel Intermediate course
Nested IF function
Don't know quite how they work and also about further logical function
Wed 16 Sep 2009, 16:19Trainer Simon said...
RE: nested IF function
Hi William,
Thank you for your question.
A Nested If is used if you want to test a cell against multiple conditions.
An IF function only allows you to test a cell using one condition.
Here is an example:
=if(c5>100,50,if(c5>30,20,10))
I hope this answers your question.
Regards
Simon
Wed 23 Sep 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |
