|Hey Mom! Learn more about the Gerber Life Insurance Grow-Up Plan!|
| ||LinkBack||Thread Tools||Display Modes|
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 12:57 PM.
|Become a AFC Supporting Member Today and Make These Ads Go Away!|
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 06:35 PM.
|The Following User Says Thank You to Jakejake For This Useful Post:|
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:|
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.
[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.
I love saving
To view links or images in signatures your post count must be 15 or greater. You currently have 0 posts.
|Thread||Thread Starter||Forum||Replies||Last Post|
|excel spreadsheet??||OttoFamily||Deal Graveyard||17||01-10-2010 04:21 PM|
|Excel spreadsheet to help calculate your transactions||1217topher||Walgreens 101||48||10-01-2009 11:47 AM|
|kroger excel spreadsheet?||hilltopperbooks||Deal Graveyard||3||02-06-2009 02:51 PM|
|Kmart-Excel Spreadsheet||newbie2008||Deal Graveyard||4||11-29-2008 07:23 PM|
|Healthy but Cheap: An Excel spreadsheet to help you track your points||mintman72||Cook's Corner||1||11-13-2008 12:52 PM|
Powered by vBulletin®
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 RC 2