# Calculating a double percentage discount

#### TheJay

##### Board Regular
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?

Last edited:

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### lrobbo314

##### Well-known Member

Code:
=A1-((A1*0.5)+(A1*0.125))

Or even better,

Code:
=A1-(A1*0.625)

=A1*0.375

#### TheJay

##### Board Regular
Thanks everyone, it's interesting seeing all your different responses. That's great.

#### igold

##### Well-known Member
You're welcome. We were happy to help.

1,089,449
Messages
5,408,291
Members
403,195
Latest member
biafrapl