Excel Spreadsheet Help

 
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-29-2011, 11:41 AM
is surfing AFC for the latest deals!
New Member
 
Join Date: Aug 2010
Posts: 43
sammilovesgymbo1 has posted more than 25 good deals
excel spreadsheet help

i am setting up a spreadsheet to track my savings but i dont want to have to hand enter the formula everytime so how can i set it to where it automatically does it for example column a is shelf price column b is value of coupon and column c is total i paid so i want to do =a-b in column c but i dont want to have to do it in each cell and what if shelf price is .97 and the value of the coupon is 1.00 when i try to do that i get an error how can i attach a copy of my excel so you can see what i am talking about

Last edited by sammilovesgymbo1; 03-29-2011 at 11:57 AM.
Become a AFC Supporting Member Today and Make These Ads Go Away!
  #2  
Old 03-29-2011, 05:28 PM

RE: excel spreadsheet help

Jakejake's Avatar
is surfing AFC for the latest deals!
Senior Member
 
Join Date: Sep 2010
Posts: 1,562
Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!
Copying formulas:
If you have that formula entered in one cell, you can click in that cell, then position your mouse over the little black box in the bottom right corner of that cell. Grab the black box and drag straight down, it should copy the formula into each cell you drag down to.

To set coupon overages to zero:
If you want .97-1 to equal zero (you aren't getting overages), then you could enter .97 in cell 1A, 1.00 in cell 1B, and in cell 1C, enter this formula: =IF(B1>A1,0,+A1-B1)

That says "IF B1 (the coupon value) is larger than A1 (the product price) then enter zero - otherwise, subtract the coupon from the product price."

Last edited by Jakejake; 03-29-2011 at 05:35 PM.
The Following User Says Thank You to Jakejake For This Useful Post:
  #3  
Old 03-29-2011, 05:59 PM

RE: excel spreadsheet help

SLance68's Avatar
is surfing AFC for the latest deals!
Rather be Boating!!
 
Join Date: Dec 2006
Location: Orlando, FL
Posts: 3,685
My Mood/Status:
SLance68 has posted more than 3000 great deals! WHOA!!SLance68 has posted more than 3000 great deals! WHOA!!SLance68 has posted more than 3000 great deals! WHOA!!SLance68 has posted more than 3000 great deals! WHOA!!SLance68 has posted more than 3000 great deals! WHOA!!SLance68 has posted more than 3000 great deals! WHOA!!SLance68 has posted more than 3000 great deals! WHOA!!SLance68 has posted more than 3000 great deals! WHOA!!SLance68 has posted more than 3000 great deals! WHOA!!SLance68 has posted more than 3000 great deals! WHOA!!SLance68 has posted more than 3000 great deals! WHOA!!
This might be an easier way to do what Jakejake wrote.

First put in the formula you want to have in the column. Then highlight the column by clicking on the first cell that has the formula and drag it down (you can go as far as you want) then click on "EDIT" then go down to "FILL" and use fill Down and that will copy the formula down.

If you want it to show negative numbers you need to format the cells - click on the top of the column so it highlights the entire column and then right click and go to format - then click on currency - then you can select how you want the numbers to show with or without the $ sign and how to show negative numbers.
The Following User Says Thank You to SLance68 For This Useful Post:
  #4  
Old 03-29-2011, 06:20 PM

RE: excel spreadsheet help

Jakejake's Avatar
is surfing AFC for the latest deals!
Senior Member
 
Join Date: Sep 2010
Posts: 1,562
Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!Jakejake has posted more than 4000 great deals! WHOA!!
Oh, yeah it would depend if you want to show .97-1 as negative .03, in which case use SLance's method, or if you want to show a 97 cent item with a dollar coupon as just free, then use my formula.
  #5  
Old 03-29-2011, 06:44 PM

RE: excel spreadsheet help

Irishsaver's Avatar
is surfing AFC for the latest deals!
Super Member
 
Join Date: Jul 2008
Location: South, NJ
Posts: 244
My Mood/Status:
Irishsaver has posted more than 200 great deals!Irishsaver has posted more than 200 great deals!Irishsaver has posted more than 200 great deals!
[quote=sammilovesgymbo1;3681297]i am setting up a spreadsheet to track my savings but i dont want to have to hand enter the formula everytime so how can i set it to where it automatically does it for example column a is shelf price column b is value of coupon and column c is total i paid so i want to do =a-b in column c but i dont want to have to do it in each cell and what if shelf price is .97 and the value of the coupon is 1.00 when i try to do that i get an error how can i attach a copy of my excel so you can see what i am talking about[/QUOTE]

You would need to save in google doc and put it into a new account or an existing account in Google doc. Use the link tab looks like a paperclip in post copy and paste and everyone an see what you are searching or looking for help with ok.
http://https://www.google.com/accounts/ServiceLogin?service=writely&passive=1209638298976 00&continue=http://docs.google.com/&followup=http://docs.google.com/&ltmpl=homepage
__________________
I love saving
To view links or images in signatures your post count must be 15 or greater. You currently have 0 posts.
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel spreadsheet?? OttoFamily Deal Graveyard 17 01-10-2010 03:21 PM
Excel spreadsheet to help calculate your transactions 1217topher Walgreens 101 48 10-01-2009 10:47 AM
kroger excel spreadsheet? hilltopperbooks Deal Graveyard 3 02-06-2009 01:51 PM
Kmart-Excel Spreadsheet newbie2008 Deal Graveyard 4 11-29-2008 06:23 PM
Healthy but Cheap: An Excel spreadsheet to help you track your points mintman72 Cook's Corner 1 11-13-2008 11:52 AM