We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel formula help please
Options
Chuzzle
Posts: 625 Forumite
in Techie Stuff
Hi I need to know the formula for showing our trade price less 35% discount.
Currently in my sheet our trade price is in column d and I'd like column f to show the price less the discount so my customer can instantly see what they will be paying without having to calculate it at all.
Currently in my sheet our trade price is in column d and I'd like column f to show the price less the discount so my customer can instantly see what they will be paying without having to calculate it at all.
Banana Lovers
Buy your bananas in bunches of 5 on Sunday. Then arrange them in order of ripeness and write a day of the week on each banana in felt pen, Monday on the ripest, Friday on the greenest to save time making those decisions on a hectic weekday morning
0
Comments
-
=d1*.065 ?0
-
Think you'll find it is
=d1*0.650 -
=d1*.065 ?
Hi Guys
No that's not what I'm looking for as that only show what the discount amount is... I want the price after discount is applied..... so D1 says £4.25 and I want F1 to then show £2.76 (£4.25 less 35% discount)
Sorry I probably didn't explain it clearly enough
Banana LoversBuy your bananas in bunches of 5 on Sunday. Then arrange them in order of ripeness and write a day of the week on each banana in felt pen, Monday on the ripest, Friday on the greenest to save time making those decisions on a hectic weekday morning0 -
Hi Guys
No that's not what I'm looking for as that only show what the discount amount is... I want the price after discount is applied..... so D1 says £4.25 and I want F1 to then show £2.76 (£4.25 less 35% discount)
Sorry I probably didn't explain it clearly enough
=d1*0.35 would show the discount
=d1*0.65 would show the price after discount. 4.25 * 0.65 = 2.76250 -
Ahem.... I'll go and hide in the corner now as you are both quite correct and I am clearly VERY dumb today.....
Sorry you are both right thanks for your help (goes and hangs head in shame..)Banana LoversBuy your bananas in bunches of 5 on Sunday. Then arrange them in order of ripeness and write a day of the week on each banana in felt pen, Monday on the ripest, Friday on the greenest to save time making those decisions on a hectic weekday morning0 -
so what would I put in for 20% or 40% .... sorry being REALLY thick todayBanana LoversBuy your bananas in bunches of 5 on Sunday. Then arrange them in order of ripeness and write a day of the week on each banana in felt pen, Monday on the ripest, Friday on the greenest to save time making those decisions on a hectic weekday morning0
-
if discount is 20%
=d1*0.2 to see the discount
or
=d1*0.8 to see the net price
for 40 % use 0.4 and 0.6 respectively.0 -
Oh its ok.....the penny has dropped lol ....65+35=100 therefore for 20% I put in .80 & 40% .60 oh dear must be getting old!! lolBanana LoversBuy your bananas in bunches of 5 on Sunday. Then arrange them in order of ripeness and write a day of the week on each banana in felt pen, Monday on the ripest, Friday on the greenest to save time making those decisions on a hectic weekday morning0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 351.1K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.6K Spending & Discounts
- 244.1K Work, Benefits & Business
- 599K Mortgages, Homes & Bills
- 177K Life & Family
- 257.4K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards