This unit begins with straight forward nested IF statements using text, then moves onto tasks where commission rates and discounts have to be calculated based on certain criteria. There are several task that require invoices to be completed with additional formulae to be inputted such as VAT and total price. The last 4 tasks have two different IF statements to calculate, with additional formulae to insert. The very last task has a 9 condition IF statement based on SQA Higher bands 1 – 9 as well determining Grades A – D, 8 & 9 based on mark %’s. ** Solutions are also included**.