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: