Formulas

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