Excel Formula Problem

Bouncy · 20 Jun 2007 at 10:23

Hi, i've made a simple spreadsheet in Excel to help me keep track of how much profit i have made on ebay but wish to create a formula to do the calculations for me but i have no idea how to do this, here is my layout:

A B C D E F G
Product Price Sold Cost Listing PayPal Postage Total
Description Inc. Delivery Price Cost Cost Cost Profit

Item 1 £26.00 £12.00 £0.18 £0.90 £3.89
Item 2 £18.00 £07.50 £0.18 £0.76 £1.89

What i need is for column G to do the Maths for me which is B-C-D-E-F=G

is it possible to do the formula once so every Item i add will get the answer in G without having to click in the box and create the formula each time ?

Many Thanks in Advance

Bouncy · 20 Jun 2007 at 10:25

Grrrrrrrrrrrrrrr i had my table all nicely alligned but when i saved it and viewed it everythings up tight to each other so i hope u can understand what i am trying to do

Bouncy · 20 Jun 2007 at 10:49

Unfortunately it's a little trickier than that

it's subtraction rather than addition i need and i don't want to be having to creat a new formula for every new product i put in, i'd like 1 formula to work for that entire Column

Bouncy · 20 Jun 2007 at 11:18

Bouncy · 20 Jun 2007 at 11:29

i must be stupid :confused:

i can only get the formula to work 1 at a time and not do the full column ? hmmmm ?? ok here is how i've done my layout if this can help you write my formula, Sorry for being slow at this

A1 to G2 Is my Headings as mentioned above

A4 is my 1st Product Description and G4 is where my profit should go
A9 is my last Product for now and G9 is where my profit should go

does this help you make my formula ?

Many Thanks

Bouncy · 20 Jun 2007 at 11:39

i'm using Office 2007 also, typed the formula into G4 and it worked wooo hoooo

Cheers Gonna try your next step n see how i get on

Bouncy · 20 Jun 2007 at 11:42

THANK YOU so much it WORKED !!!!!! God your Good hehehehe now do you Fancy explaining what the hell you had me type into G4 to get that to work? Just incase i need to do this again sometime by myself

Bouncy · 20 Jun 2007 at 11:51

Thankyou so much, this was very helpful and much appreciated