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 £1250.00 is £312.50. This means the total including the reduction is £937.50.
I know I can achieve this by outputting £1250.00 and £312.50 in different cells, but I'm trying to achieve this using as few cells as possible.
I tried total/8 but that only gets me part way with £312.50, but then the spreadsheet doesn't know what figure to take this away from.
Can anyone figure this out please?
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 £1250.00 is £312.50. This means the total including the reduction is £937.50.
I know I can achieve this by outputting £1250.00 and £312.50 in different cells, but I'm trying to achieve this using as few cells as possible.
I tried total/8 but that only gets me part way with £312.50, but then the spreadsheet doesn't know what figure to take this away from.
Can anyone figure this out please?
Last edited:
