# Any Excel Boffins Out there?

HELLP!! - I need a formula and I cant quite get my head around it.

I am trying to create an invoice, with a feature so we can put a percentage in one box, say 10%, and the formula will subtract 10% from the subtotal box.

Thing is, the subtotal box has a formula in it already to add up the product totals. This is what the formula is - =SUM(I28:J40)

Now the percent box is under this, so how would I get the sub total box to change if I put a percentage in the discount box? say 10% for example?

many happy cheers and rep waiting for the answer lol!!

I am trying to create an invoice, with a feature so we can put a percentage in one box, say 10%, and the formula will subtract 10% from the subtotal box.

Thing is, the subtotal box has a formula in it already to add up the product totals. This is what the formula is - =SUM(I28:J40)

Now the percent box is under this, so how would I get the sub total box to change if I put a percentage in the discount box? say 10% for example?

many happy cheers and rep waiting for the answer lol!!

Original Poster

I was worried about that

Original Poster

Thanks for the reply, issue is, the discount percentage will most likely change all the time c.

=SUM(I28:J40)*(1-J41)

Put 10% in J41 or the cell you want to use and edit the formulae above

Banned

+1

Where CELL# is the cell where you want to put the discount percentage.

Original Poster

this works a treat. Thanks guys. Ill do the rep now!