Wanted: Service Excel Question - From A Newbie

[DomainEmpire.com]

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.

 

[dmyre]

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...

 

[DomainEmpire.com]

Great, thanks a lot for the clear explanation, problem solved

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

 

[DomainEmpire.com]

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

 

[Johnn]

Same thing but instead of b1+30 you enter b1*1.25 (25% in this case)

 

[dmyre]

2% would be =B1*1.02

 

[DomainEmpire.com]

I got it now, thanks to both for helping

 

[Johnn]

No problem
First consultation is free.
Next time we will charge you.

 

[DomainEmpire.com]

Haha ok