• Welcome to DNForum.com - Domain Investor Forum, Free Domain Marketplace and a community for 45+ domain pros
    If you are new to domains and looking to buy, sell and learn about domains then you have come to the right place. DNForum is the oldest global domain name community on the internet and continues to grow every day. There are over 45,000 domainers on DNForum doing everything from buying domains, selling domains, using our free in-house built tools, learning about domains and discussing domains. Take a minute and Register.

Wanted: Service Calculating Bulk % In Excel - How Doing That ?

DomainEmpire.com

Level 7
The Originals
Legacy Platinum Member
Joined
Aug 13, 2002
Messages
2,539
Reaction score
58
Hi All,

I'm not skilled with excel but I need to learn how increasing of a given x% a large amount of prices.

To be more specific, we've just put together our new domain inventory (over 2200 domains) so we've a 2 column file: domains, prices.
All those prices need to be increased of a flat 5%; how doing that easily, instantly and in bulk so that the new increased values will replace the old ones ?

Considering my limited excel experience, if someone might help, I'd send you privately the file containing all prices to increase so you might explain, step by step, what doing to get the expected result, thanks.
 
You add a third column that looks something like =A1*1.05. Copy and paste that formula into all the cells below using your shift + arrow keys or holding down your mouse button. Once your third column has been completed, copy the column and "special" paste over the second column using the "values only" selection.

If you PM me the file, I can do it for you in about a minute.
 
Back
Top Bottom