This is fairly difficult to explain.
I want a spreadsheet to calculate 50% of the total and then calculate 25% of that 50%. This should be output as the total amount discounted and then as the total payable in another cell.
For example, the total is £2500.00. 50% reduction is £1250.00. 25% of...