Fiat Coupe Forum
- Founded by Kayjey & James Northam
- Funded by the Club for the benefit of all owners
Fiat Coupe Club UK
join the club
Fiat Coupe Forum
 
» Announced
    Posting images


» Related sites
    Main club site
    fiatcoupe.net


» External data
    owners listed
 
Who's Online Now
2 registered members (2 invisible), 121 guests, and 2 spiders.
Key: Admin, Global Mod, Mod
Forum Statistics
Forums69
Topics113,525
Posts1,340,213
Members1,779
Most Online731
Jan 14th, 2020
Top Posters(All Time)
barnacle 33,512
stan 32,122
Theresa 23,287
PeteP 21,474
bockers 21,070
JimO 17,917
Nigel 17,366
Edinburgh 16,622
RSS Feeds
Club Events
Club Information
Track Events
Rolling Road/RWYB
Social Events
Non-UK Events
Coupé Related Chat
Coupé Spotting
Coupé News/Press
Buying/Selling Advice
Insuring a Coupé
Basic FAQ's
How to Guides
Forum Issues
Technical Problems
General Maintenance
Styling
Tuning
Handling
ICE and Alarm
Coupés for Sale
Coupés Wanted
Parts for Sale
Parts Wanted
Group Buys
Business Forum
Other Vehicles for Sale/Wanted
Other Items for Sale/Wanted
Haggling/Offers
Ebay links
Other Cars
Other Websites
General Chat
Previous Thread
Next Thread
Print Thread
Excel help #1604637
17/07/2017 14:23
17/07/2017 14:23
Joined: Nov 2007
Posts: 2,083
Pontypandy
mr_tickle Offline OP
Club member 1455
mr_tickle  Offline OP
Club member 1455
Competition Level

Joined: Nov 2007
Posts: 2,083
Pontypandy
Starter for 10 points:

I have a price list of our product on a worksheet that has 20 tabs and on each sheet there are a list of prices for each product.

I need to apply a global price decrease of 15% for each price.

Is there a way of setting up a shortcut or key command so that I can highlight a cell or range of cells and it will do the reduction, or alternatively please suggest a method of doing this

The prices are in various columns and rows and in different cells on each tab.

Thanks


[Linked Image]
Re: Excel help [Re: mr_tickle] #1604638
17/07/2017 15:34
17/07/2017 15:34
Joined: Dec 2005
Posts: 8,381
Lightwater, Surrey
DaveG Offline
Club Treasurer Member 311
DaveG  Offline
Club Treasurer Member 311
Je suis un Coupé

Joined: Dec 2005
Posts: 8,381
Lightwater, Surrey
1. You can set up extra columns or rows on each sheet to show the discounted price as a function of the original price, eg: discounted price = old price * (1 - GLOBAL_DISCOUNT) where GLOBAL_DISCOUNT refers to a cell you have given that label to on a sheet somewhere

2. Set up the discount in a cell as a fraction (eg: 15% discount = 0.85) and highlight that cell, right click and select Copy (or press Ctrl-C), then select all the cells containing the original prices, and right click, select Paste Special, click on Values (Paste) and Multiply (Operation) and voila, all your prices will have been multiplied by 0.85 = 15% discount.

But you have to to do the Copy/Paste Special (Multiply) sheet by sheet (I think). Plus if you change your mind and want the original prices back, you have to "undo" the discount, so I would always use method 1 to provide some transparency into what's going on.


1996 Portofino 20vt & 2000 Pearl White Plus
1985½ & 2016 2017 Fiat 124 Spider + XF Sportbrake
Re: Excel help [Re: DaveG] #1604655
18/07/2017 06:04
18/07/2017 06:04
Joined: Nov 2007
Posts: 2,083
Pontypandy
mr_tickle Offline OP
Club member 1455
mr_tickle  Offline OP
Club member 1455
Competition Level

Joined: Nov 2007
Posts: 2,083
Pontypandy
Thanks Dave smile

Job done

type


[Linked Image]

Powered by UBB.threads™ PHP Forum Software 7.7.1
(Release build 20190129)
PHP: 7.3.33 Page Time: 0.009s Queries: 14 (0.004s) Memory: 0.7473 MB (Peak: 0.7930 MB) Data Comp: Off Server Time: 2024-03-19 11:15:24 UTC