Any Excel Boffins Out there? - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Any Excel Boffins Out there?

aircanman Avatar
8y, 4w agoPosted 8 years, 4 weeks ago
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!!
aircanman Avatar
8y, 4w agoPosted 8 years, 4 weeks ago
Options

All Comments

(10) Jump to unreadPost a comment
Comments/page:
#1
=xx/10 replace xx with the cell reference for the subtotal eg b4
#2
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
#3
Might need to use other boxes for the two individual formulas and then the subtotal box with a formula to combine them or something
#4
Titchimp
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
#5
ctuk
=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.
1 Like #6
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#7
RoyalRenegade;3833183
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
#8
=SUM(I28:J40)*(1-(CELL#/100))

Where CELL# is the cell where you want to put the discount percentage.
#9
Beat me to it by miles haha! Oh well.
#10
RoyalRenegade
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

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!