#1
|
|||
|
|||
How to add a fixed value to an entire column?
Hello, I am a wholesaler and have received an inventory spreadsheet with pricing for products from my Distributor, in order for me to send the sheet to my retailers, I first need to update the prices of each product to add my markup so if I should need to add $3 to every item's pricing, is there a way I can add the $3 to EVERY product's existing pricing and have th sheet updated to reflect MY pricing please? |
#2
|
|||
|
|||
=sum(A1+3)
Where A1 is the suppliers price |
#3
|
|||
|
|||
sorry, I'm not all that familiar with spreadsheet editing, under "Auto sum" when clicking on the "Formulas" tab, in the dropdown menu which appears when I click on the arrow on the Auto Sum tab I click the SUM option, this shows some numbers showing up elsewhere in the sheet? I have 2 pricing in the original sheet, the wholesale pricing I am getting from my distributor when ordering more than 48+ pcs, this is under Column D and the pricing for any amount less than 48 pcs in column E, help?
|
#4
|
|||
|
|||
If you attach the sheet I could have a look for you. I'll try to help you.
|
#5
|
|||
|
|||
If you open a new spread sheet and type 3 in cell A1 and in cell B1 type =sum(A1+3) it will calculate it for you, then it's a case of copying the formulae down the page to replicate it to all the stock.
|
#6
|
|||
|
|||
That is still baffling me, I'll try to attach the sheet here
|
#7
|
||||
|
||||
No need for fancy formulas or whatever
Enter the value 3 in any empty cell and copy it Select the range(s) where you need the value added (entire range(s) adjacent or not) Right click and click Paste Special Select Add under the Operation header - Ok - Done
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#8
|
|||
|
|||
I highlighted the entire E column, right click on it then a new small window opens, the attached shot is what I am seeing?
|
#9
|
||||
|
||||
Did you copy value 3 in an empty cell somewhere in the same sheet?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#10
|
|||
|
|||
yes, it turned into 3.00
|
#11
|
||||
|
||||
Did you copy (or cut - either works) the 3 after inputting it?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#12
|
|||
|
|||
yes I did copy the 3.00 then selected the entire E column, right click in it then chose "Paste Special" and that's when the new window opens BUT I closed the sheet re-opened it tried your instructions again and this time when I right click and Paste Special another smaller window opened and I see the option to choose ADD so it workds now, thank you very much guys!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automatically enter date into a column and make that column read only | Mr Davo | Excel | 1 | 10-29-2012 01:07 AM |
How to use fixed duration, fixed work and have resources/units leveled automatically? | Joeb | Project | 3 | 06-25-2012 04:18 PM |
free slack changes when i paste from fixed cost to cost1 column | ketanco | Project | 5 | 02-03-2012 06:17 AM |
NETWORKDAYS calculation for entire column | Salient | Excel | 0 | 07-11-2011 03:58 PM |
Formula not getting copied to entire column | theacegary | Excel | 1 | 11-29-2010 02:18 PM |