The differences between them are not extensive so you can work in Excel 2010 easily if you are familiar with Excel 2007. You can save your files so that Excel 2007 will recognise them.
The IF functions works on the primary IF-THEN-ELSE logic.
Which is to say,
IF- Check for a condition.
THEN- Value if the condition so checked is true.
ELSE- Value if the condition so checked is...
Microsoft Excel is used to create spreadsheets. You can use it to create sheets such as budgets. It's made up of columns and rows that allow you to calculate totals using formulas.