Enjoy unlimited access to all forum features for FREE! Optional upgrade available for extra perks.
Domain summit 2024

Excel Question - From A Newbie

DomainEmpire.com

Level 9
Legacy Platinum Member
Joined
Aug 13, 2002
Messages
2,538
Reaction score
58
Feedback: 326 / 0 / 0
We've no experience with excel but this's a quite easy task for some more skilled than us :)

We've an inventory of 2,800 prices, we need to add $30 to each price.
May you explain, step by step, how applying this change, please ?

Thanks in advance for helping.
 
Domain summit 2024

dmyre

Level 9
Legacy Exclusive Member
Joined
Apr 6, 2002
Messages
2,685
Reaction score
70
Feedback: 63 / 0 / 0
I'm a novice as well, but this may help until someone else comes along

First, copy your spreadsheet into a new file so you can make the changes there.
Now, if the pricing is in column b and column c is empty follow these instructions:

1. Select c1
2. Find the function bar (looks like fx)
3. Enter this =b1+30 (press enter to execute the formula)
4. Select c1 again, which will highlight the box
5. Grab the lower righ hand corner and pull it down 2800 spaces.

That should add 30 to each number in column b.
Hope it helps...

 
Last edited:

DomainEmpire.com

Level 9
Legacy Platinum Member
Joined
Aug 13, 2002
Messages
2,538
Reaction score
58
Feedback: 326 / 0 / 0
Great, thanks a lot for the clear explanation, problem solved :)

Should you ever need anything from us, don't hesitate to ask.
 

DomainEmpire.com

Level 9
Legacy Platinum Member
Joined
Aug 13, 2002
Messages
2,538
Reaction score
58
Feedback: 326 / 0 / 0
Do you know how increasing prices of a given % too ?
Now I got the mechanism, I'd only need the formula to increase all prices of a 2% for instance.
Once I'll have it, I'll be able to edit the parameters to use for our purposes.

Thanks again
 

The Rule #1

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

Sedo - it.com Premiums

IT.com

Premium Members

AucDom
UKBackorder
Be a Squirrel
MariaBuy

New Threads

Our Mods' Businesses

Free QR Code Generator by MerchArts
UrlPick.com

*the exceptional businesses of our esteemed moderators

Top Bottom