Excel problem!

Black Lion · (#1 (**permalink**))

Ok I'm back doing battle with excel again a bit rusty after my last run in with it but things are really moving now and I need to sort this out.

How do you add to the value of something? I need to add VAT (17.5%) to a formula but it won't add to its value properly... can anyone help?
How do I copy formlas? Too many lines to be typing it all in again. Has to change to suit the new line.
On some lines I'm getting a monetary value rather than just a numerical one, showing -£1.00- rather than just -1- how do I change it?

I'm working on an inventory list andI've finally got somestockin, really wanna get it down tight and intergrate the inventorywith my sales sheet and cashflow so at the end of the day/week someone can total up the days sales and have it all work itself out, have also managed to intergrate it with a cool looking line chart showing how many of each product has been sold.

If anyone can help or point me in the right direction it'd be brilliant, I don't like that paperclip thing it just annoys me.

Any advice is appreciated.

Peace niceone.gif

RL

Vezz. · (#2 (**permalink**))

Rebel-Lion wrote:

Quote:

Ok I'm back doing battle with excel again a bit rusty after my last run in with it but things are really moving now and I need to sort this out.

How do you add to the value of something? I need to add VAT (17.5%) to a formula but it won't add to its value properly... can anyone help?

i.e 100*17.5%+100=117.50

How do I copy formlas? Too many lines to be typing it all in again. Has to change to suit the new line.

hover over the bottom right of the cell, click then drag

On some lines I'm getting a monetary value rather than just a numerical one, showing -£1.00- rather than just -1- how do I change it?

Click on the cell, or highlight the columns or rows, right click then choose format cells, then choose number and ok.

I'm working on an inventory list andI've finally got somestockin, really wanna get it down tight and intergrate the inventorywith my sales sheet and cashflow so at the end of the day/week someone can total up the days sales and have it all work itself out, have also managed to intergrate it with a cool looking line chart showing how many of each product has been sold.

If anyone can help or point me in the right direction it'd be brilliant, I don't like that paperclip thing it just annoys me.

Any advice is appreciated.

Peace niceone.gif

RL

Any more help, just holla!

Black Lion · (#3 (**permalink**))

Whooo!

Excel-lent! niceone.gif

Theold man is pissed off as well,always a good sign. banana.gif

Got all that, the VAT and everything but now I'm stuck on how to get all formulas in one. So far I'm doing this;

=G5+G6+G7+G8...

And so on and so forth but if I need to add more inventory it probably won't show and by the time I'm finished I'll looklike Lloyd but with a hunched back and curled fingers.

No one deserves that. .lol.

Might stay up all nightand finish this.

Thanks again.

Vezz. · (#4 (**permalink**))

I actually answered this as I thought you asked for it!!!

Enter the formula in a cell, then drag it into the cells you want to populate.

Any more?

Vezz. · (#5 (**permalink**))

Rebel-Lion wrote:

Quote:

Whooo!

Excel-lent! niceone.gif

Theold man is pissed off as well,always a good sign. banana.gif

Got all that, the VAT and everything but now I'm stuck on how to get all formulas in one. So far I'm doing this;

=G5+G6+G7+G8...

And so on and so forth but if I need to add more inventory it probably won't show and by the time I'm finished I'll looklike Lloyd but with a hunched back and curled fingers.

No one deserves that. .lol.

Might stay up all nightand finish this.

Thanks again.

Misread again...need to get some sleep!

Quote:

=sum(cell references). It will highlight the cells, so you just drag your cursor.

Quote:

I hope that makes sense!

TheDogon · (#6 (**permalink**))

Vezz. wrote:

Quote:

Rebel-Lion wrote:

Quote:

Whooo!

Excel-lent! niceone.gif

Theold man is pissed off as well,always a good sign. banana.gif

Got all that, the VAT and everything but now I'm stuck on how to get all formulas in one. So far I'm doing this;

=G5+G6+G7+G8...

And so on and so forth but if I need to add more inventory it probably won't show and by the time I'm finished I'll looklike Lloyd but with a hunched back and curled fingers.

No one deserves that. .lol.

Might stay up all nightand finish this.

Thanks again.

Misread again...need to get some sleep!

Quote:

=sum(cell references). It will highlight the cells, so you just drag your cursor.

Quote:

I hope that makes sense!

Quote:

Shoot, he could even just go to a cell and type "+(" then drag and highlight all the cells in the column he want to add up. Then close it with a ")". That will add all of the cells and put the value in the starting cell.

Quote:

Vezz. · (#7 (**permalink**))

I didn't mean he should enter the references one by one!

It's the same thing, different method.

I think it was Excel 2000 that didn't allow you to do it the way you described, so I've always done it the =sum way.

Vezz. · (#8 (**permalink**))

Vezz. · (#9 (**permalink**))

TheDogon · (#10 (**permalink**))

Vezz. wrote:

Quote:

I didn't mean he should enter the references one by one!

It's the same thing, different method.

I think it was Excel 2000 that didn't allow you to do it the way you described, so I've always done it the =sum way.

Quote:

I understood you. But I am using 2003. They restored that feature, I guess.

Black Lion · (#11 (**permalink**))

Vezz's one seemed to work, not sure what version I'm using.

Its managed to get the total wrong though, its got the total value fine but the total value plus VAT is 5p off. Can't be the formula, unless it rounded it alldownor something.

Baffling...

Won't change it with the format function either.

Slight hiccuptrying to get all the stock list onto a next page. Can cut and paste but it dosen't change when the inventory is updated.

I'll ask the clip....

Black Lion · (#12 (**permalink**))

Got it.. not sure why it was pissing me off.

Still got the VAT 5p short though.

Vezz. · (#13 (**permalink**))

I've never been able to fix the rounding problem in all my years of using Excel.

Do you get a green triangle in the corner of the cell?