User Tag List
Results 1 to 5 of 5
Thread: Microsoft Excel Help Please :)
-
Mon, May 30th, 2011, 11:23 AM #1
- Join Date
- May 2011
- Location
- Tamworth, Ontario
- Posts
- 294
- Likes Received
- 0
- Trading Score
- -1 (0%)
I'm trying to make up a simple spreadsheet on Microsoft Excel Starter for my weekly shopping trips. Right now I have a column for the item, the price, coupon and the total.
What I want to do is have the coupon column subtract from the price column, have those two total and then have a final total at the bottom of the page. I know it's very simple, but I can't figure out how to do it.
Any guru's out there?This thread is currently associated with: Microsoft
-
-
Mon, May 30th, 2011, 11:26 AM #2
- Join Date
- Sep 2008
- Location
- Ottawa
- Posts
- 1,616
- Likes Received
- 28
- Trading Score
- 65 (100%)
There is probably a template online - but you will need to add up the column with the coupons and the minus it from the shopping total -- do you know what version you are using?
-
Mon, May 30th, 2011, 11:36 AM #3
- Join Date
- May 2011
- Location
- Tamworth, Ontario
- Posts
- 294
- Likes Received
- 0
- Trading Score
- -1 (0%)
-
Mon, May 30th, 2011, 11:37 AM #4
- Join Date
- May 2010
- Location
- Hamilton, ON
- Age
- 46
- Posts
- 23,423
- Likes Received
- 14245
- Trading Score
- 254 (100%)
This is the formula for sum =SUM(A2:A4) plug this in and change the cell numbers to whatever you want. You can drag the formula down the column to add up subsequent rows.
For the difference between to columns the formula is =A2-A3
-
Mon, May 30th, 2011, 11:39 AM #5
- Join Date
- Oct 2008
- Location
- SK
- Posts
- 118,045
- Likes Received
- 147799
- Trading Score
- 29 (100%)
I don't do it myself, but an SC member posted some excel savings charts - check here on post 112
http://forum.smartcanucks.ca/90767-d...ator-canada-8/
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)