Help with a spread sheet

[mcurl]

Hello Everyone,

I am not sure if I am posting this where it needs to be, if not I am sure the mods will move it for me . Anyway I know what I want on the spread sheet, just not how to formulate the cells to calculate on their own. I am not wanting someone to do this for me (unless they want too), but to possibly walk me through it. I do have yahoo messanger mcurl1821 if anyone could help I would greatly appreciate it.

Thanks,
Chelle

[MOMIOF2]

Originally Posted by mcurl Hello Everyone, I am not sure if I am posting this where it needs to be, if not I am sure the mods will move it for me . Anyway I know what I want on the spread sheet, just not how to formulate the cells to calculate on their own. I am not wanting someone to do this for me (unless they want too), but to possibly walk me through it. I do have yahoo messanger mcurl1821 if anyone could help I would greatly appreciate it. Thanks, Chelle

Hi, did you ever get help with a spread sheet? I am looking for help also.

[jonjaktez]

To do a calculation in Excel, you need to tell the cell what to do.

Examples: (type what is between the " ")

Cell A1 is "2"
Cell B1 is "3"
Cell C3 is "= A1 + B1" (the addition of 2 + 3 will show in the cell)
Cell C3 is 5


ABC1235



Same Cells
"2"
"3"
"= A1 * B1"
6


ABC1236

[jonjaktez]

Try this website

Excel Formulas - Microsoft Excel Formulas - Excel Formulas Tutorial

[MommaDuck01]

I do a spreadsheet for so many things. I need lots of info to make me happy!

Here are my column headers:
A) category (use your organizer categories so you can sort the spreadsheet and search for coupons easily)
B) Item (I list the item on sale as well as details - size, etc.)
C) Quantity
D) Price (so if it was 2/$5, I would list 2 in qty and $5 in price; I can change this later if I want to buy a different qty)
E) Extra Bucks or Register Rewards
F) MIR's
G) EasySaver coupon/in-ad coupon, etc
H) Coupons (the one(s) that I have in my binder)
I) End Cost (each row would be set to calculate "=SUM(Dx:Hx)" x being the correct row number)
J) Price Each (rows would calculate "= Ix/Cx")
K) Amount paid at store (rows would calculate "=SUM(Dx,Gx,Hx)")
L) Details/notes - any reminder or details that don't fit any where else like "coupons expire on Tuesday!"

I make a tab for each week and separate the worksheet with store names and then sort under that by category so it is easy to shop by aisle.

Hope this makes sense to you! Like I said, it may be too detailed for what you want but I like lots of info. It tends to print small (adjust the font and all to fit) but I write small too so it doesn't bother me. I also adjust the page breaks so I might have one store printed out on one page and two on another.

[MommaDuck01]

Oh, forgot to add. When entering the price for the coupons, MIR's, etc., enter them as negative numbers so they will calculate correctly (ex: -1.00).

[MOMIOF2]

Originally Posted by MommaDuck01 Oh, forgot to add. When entering the price for the coupons, MIR's, etc., enter them as negative numbers so they will calculate correctly (ex: -1.00).

Thanks, it does makes sense. I am about to start putting mine together.