Monthly Archives: March 2019

Microsoft Excel – the IFS function

Are you using Office 365? If so, instead of a nested IF, you can use the new IFS function. Consider the example below: We would generally use a nested IF to work out the exam score, the formula being: =IF(B2>80,”A”,IF(B2>70,”B”,IF(B2>60,”C”,”FAIL”))) … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Office 365 | Tagged , , | Leave a comment

Microsoft Excel – working out school year from date of birth

School years run from September to August, so in general it depends on both the month that a child is born in as well as the year. So if you have a list of dates of births and need to … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment