98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Medium Priority · Version 2007
IF Function!!
Dear Paul
Thank you for attending Excel 07 intermediate course. I hope you enjoyed the course and have started to put the new topics into practice!!
If function is a logical function which returns a value if the statement is TRUE and returns a different value if it is FALSE.
A typical situation where If Function can be used is to calculate commission for salespeople based on their Total sales for a specific period.
Another typical example could be that if you have minimum budget for particular costs and you want to know if you are "over Budget" or "under Budget" you can use the IF function.
I believe that if you understand the syntax (Structure) of the Function then you can use it for many more situations that are specific to you either at home or at work!!
A math quiz ask the question
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:Return to the active cell after scrollingWhen I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen. |