Hey Mom! Learn more about the Gerber Life Insurance GrowUp Plan! 
 LinkBack  Thread Tools  Display Modes 
#1
 
 
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 =ab 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; 03292011 at 11:57 AM. 
Become a AFC Supporting Member Today and Make These Ads Go Away!  
Advertisement  Advertisement 
#2
 
 
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 .971 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,+A1B1) 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; 03292011 at 05:35 PM. 
The Following User Says Thank You to Jakejake For This Useful Post:  
#3
 
 
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
 
 
Oh, yeah it would depend if you want to show .971 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
 
 
[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 =ab 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/<mpl=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  
 
Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
excel spreadsheet??  OttoFamily  Deal Graveyard  17  01102010 03:21 PM 
Excel spreadsheet to help calculate your transactions  1217topher  Walgreens 101  48  10012009 10:47 AM 
kroger excel spreadsheet?  hilltopperbooks  Deal Graveyard  3  02062009 01:51 PM 
KmartExcel Spreadsheet  newbie2008  Deal Graveyard  4  11292008 06:23 PM 
Healthy but Cheap: An Excel spreadsheet to help you track your points  mintman72  Cook's Corner  1  11132008 11:52 AM 
Powered by vBulletin®
Copyright ©2000  2016, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 RC 2