posted on June 25, 2001 12:44:20 PM new
I am not much of an expert but what I suggest is using an add function. First things first, the letters in Excel represent columns...so you would be looking at a solution to be used in COLUMN H (Not ROW H).
Lets work with ROW 1. If you wanted to get the total provided in cell E1 (the total for the auction) plus $3 into cell H1 you can use the following function:
=E1 + 3
This will give you the answer you are looking for. And to make life easier just click on the cell and copy it down your entire spreadsheet, that way you will be able to add $3 to all of your closing auctions. Hope that helped.
posted on June 25, 2001 01:05:31 PM new
=E1 +3 doesn't work.
=E2167 +3 does work.
2167 is the row that I am working on at the moment.
How would I make row 2168 and beyond work with that formula?
I don't want to go back to Row 1 and re-format everything, because we do change the shipping amount once and a while due to shipping more than one at a time.
posted on June 25, 2001 01:54:14 PM new
If you postage is in cell H3 and your data is in E2167 use the formula E2167+H$3
The $ in the formula will make sure that the number is always the same and not incremented when you copy and paste or click that little black box around the edge of your cell and drag.
Conversely if there is a $ in your formula, take it out as it is locking in that line number.
