Found 22nd Dec 2008
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!!

  1. Misc
Groups
  1. Misc
10 Comments

=xx/10 replace xx with the cell reference for the subtotal eg b4

you could changed the subtotal box to =(SUM(I28:J40))*0.9 if not you'll have to create another box because otherwise the formula is going round in circles and excel doesnt like that so it wont work. hope this helps

Might need to use other boxes for the two individual formulas and then the subtotal box with a formula to combine them or something

Original Poster

Titchimp;3833136

Might need to use other boxes for the two individual formulas and then … Might need to use other boxes for the two individual formulas and then the subtotal box with a formula to combine them or something



I was worried about that

Original Poster

ctuk;3833099

=xx/10 replace xx with the cell reference for the subtotal eg b4



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

Just do the following
=SUM(I28:J40)*(1-J41)

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

Banned

RoyalRenegade;3833183

Just do the following- =SUM(I28:J40)*(1-J41)Put 10% in J41 or the cell … Just do the following- =SUM(I28:J40)*(1-J41)Put 10% in J41 or the cell you want to use and edit the formulae above


+1

=SUM(I28:J40)*(1-(CELL#/100))

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

Beat me to it by miles haha! Oh well.

Original Poster

RoyalRenegade;3833183

Just do the following =SUM(I28:J40)*(1-J41)Put 10% in J41 or the cell you … Just do the following =SUM(I28:J40)*(1-J41)Put 10% in J41 or the cell you want to use and edit the formulae above



this works a treat. Thanks guys. Ill do the rep now!
Post a comment
Avatar
@
    Text
    Top Discussions
    1. Gala Bingo/Games. Deposit £5 get £40 cashback. Quidco - new Gala members11
    2. Has the amount of Apple fanboys increased on the site after the redesign?11
    3. Urgent help needed with travel agent56
    4. Submit Mobile Deals from Comparison sites22

    See more discussions