Membership is FREE, giving all registered users unlimited access to every DNForum feature, resource, and tool! Optional membership upgrades unlock exclusive benefits like profile signatures with links, banner placements, appearances in the weekly newsletter, and much more - customized to your membership level!

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

DomainEmpire.com

Level 9
Legacy Platinum Member
Joined
Aug 13, 2002
Messages
2,538
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.
 

INFORG

Level 8
Legacy Platinum Member
Joined
Aug 24, 2002
Messages
1,712
Reaction score
93
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.
 

Who has viewed this thread (Total: 1) View details

Who has watched this thread (Total: 2) View details

The Rule #1

Do not insult any other member. Be polite and do business. Thank you!

Members Online

Premium Members

Upcoming events

Latest Listings

Our Mods' Businesses

*the exceptional businesses of our esteemed moderators

Top Bottom