How do I add one fixed amount to several selected cells at once?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet showing the costs of shipping via UPS on all zones for
several different weights. I need to add $15 to all the costs as our
surcharge for handling. Please help with a simple formula to add 15 to all
selected cells.
 
On a seperate cell insert the value 15
Copy that value (15).
Highlight the cells you want to add the 15 to.
Click on Edit - Paste Special
Underneath the Paste section Select "Formula"
Underneath the Operation section select "Add"
Click OK

That should add 15 to all the cells you selected. Feel free to delete the 15
you inserted on a seperate cell it wont affect the formula you just pasted.
 
In a blank cell type 15, copy the cell, select the cells to which you want to
add 15, click Copy > Paste Special, under Operations click Add, the OK.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help making postage calculator based on a given weight 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
how to best structure this? 3
How do I consolidate data from several spreadsheets into one. 4
Date calculation cell became #NAME?. 1
I want to add totals using several criteria from different column 3
find values that add up to certain amount 12
how do i add a formula to a cell that will add or subrtact from d. 2

Back
Top