Pages: [1]   Go Down

AuthorTopic: i never thought i would ask this.... (excel help)  (Read 1367 times)

0 Members and 1 Guest are viewing this topic.

Offline TDi90

  • Posts: 2712
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Rolly - Under Construction...
  • Referrals: 0
i never thought i would ask this.... (excel help)
« on: December 06, 2007, 13:26:44 »
:oops: the most annoying thing is i did a level computing!!

but does anyone know how to add some cells up in excel.
i am struggling, and i dont think its because i dont know how to do it i think its cos im going wrong somewhere.

i have antered numbers into cells A6 and A7 and A8 and have declared the cells as NUMBER.

now in a seberate cell i have put this equasion: =A6:A8 (i also tried: =A6+A7+A8 still wont work)
but the answer wont come up?  :?

any ideas anyone?
this is really poor of me i know  :evil:


Rob
Logged
TDi90
~The DFYTR Moderation Team~

Offline Lucy1978

  • Posts: 516
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #1 on: December 06, 2007, 13:28:49 »
=sum(A6:A8)
Logged

Offline TDi90

  • Posts: 2712
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Rolly - Under Construction...
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #2 on: December 06, 2007, 13:32:19 »
ahh yes thats the one....

thank you! god how embarressing....
Rob  :oops:
Logged
TDi90
~The DFYTR Moderation Team~

Offline hodgei

  • Posts: 36
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #3 on: December 06, 2007, 13:54:32 »
Confused - =A6+7+A8 should have worked... :-k
Logged
1994 Disco V8i - Stock for now... :P
I'm doing my bit for the environment - I'm offsetting - at least, I park my V8 next to a Prius at work - does that count?
1999 Honda NTV650 Deauville
2004 Jaguar X-Type Estate - for the wife ;-)

Offline mike142sl

  • Posts: 750
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #4 on: December 06, 2007, 15:33:49 »
Quote from: "hodgei"
Confused - =A6+7+A8 should have worked... :-k
You need the SUM command otherwise it won't know what you're asking it to do. Could also be COUNT etc.
Logged
Mike
Disco TD5 Landmark
SYM GTS250i Voyager
Swift Challenger 490

Offline fasthands

  • Posts: 60
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #5 on: December 06, 2007, 16:01:38 »
Don't be embarressed I don't even have a clue what you are talking about!! :lol:  :lol:  :lol:  computing I am just getting into it all, and have discovered Ubuntu/Linux and I am running my pc on it instead of crappy Windows. I have learned hell of a lot, from just trying stuff. and my pc work hell of a lot better now. and it's FREE!! :D  :D  :D
Just thought I would share that with you,because I am so chuffed with myself for managing to set my pc up on Ubuntu and getting it to actually work. BETTER :shock:  :shock:. Sorry.  :oops:
Logged
Land Rover repair guide, Don't fix anything, because if you do something else always breaks, so fix nothing and nothing will break!!!

Offline TDi90

  • Posts: 2712
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Rolly - Under Construction...
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #6 on: December 06, 2007, 16:18:59 »
well done fasthands!
its just i actually did computing/IT for 5 years  :oops:
and then after not doing it for 1 year i forget lots of stuff  :oops:  :roll:
Logged
TDi90
~The DFYTR Moderation Team~

Offline Skibum346

  • Posts: 1975
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • T. A. N. S. T. A. A. F. L.
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #7 on: December 06, 2007, 16:49:38 »
Quote from: "mike142sl"
Quote from: "hodgei"
Confused - =A6+7+A8 should have worked... :-k
You need the SUM command otherwise it won't know what you're asking it to do. Could also be COUNT etc.


Rubbish!  :shock:

Unless it's Excel 1.1 from windows 3.1!!!   :lol:

Just tested it for completeness... "=A6+A7+A8" should have worked.
Logged

Offline V8MoneyPit

  • Moderator
  • ***
  • Posts: 5077
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +1/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #8 on: December 06, 2007, 17:18:31 »
Isn't there a 'function' button at the top listing the main calculating functions?
Logged
Rgds
Steve

"Reality is wrong. Dreams are for real."

Land Rover build:
www.daisythediesel.com

Photos (my other passion and weakness):
http://www.flickr.com/photos/v8moneypit/

Offline TDi90

  • Posts: 2712
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Rolly - Under Construction...
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #9 on: December 06, 2007, 17:22:55 »
bum, your right. you can do it either way. but with sum its a little quicker  :)
Logged
TDi90
~The DFYTR Moderation Team~

Offline Thrasher

  • Administrator
  • *****
  • Posts: 3102
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +7/-0
    • Northampton
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #10 on: December 06, 2007, 17:53:08 »
Highlight cells, pick your new cell and click the SUM button? Simple ....
Logged
--
Neil

Offline fasthands

  • Posts: 60
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #11 on: December 06, 2007, 17:57:44 »
It feels great to be liberated from Windows, it's Overpriced rubbish!!!
And I feel like a computer buff,  Yea!!! :lol:  :lol:  :lol:
Logged
Land Rover repair guide, Don't fix anything, because if you do something else always breaks, so fix nothing and nothing will break!!!

Offline auf_wiedersehen_pet

  • Posts: 1179
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #12 on: December 06, 2007, 19:36:32 »
Next steps........

Goal Seek?
Conditional Formatting?
Look Up Tables?

 :twisted:  :twisted:  :twisted:
Logged
Rob Steele

1995 Land Rover Discovery 300 TDi - Everyday Car (Ex Jap)
2007 Toyota Avensis 2.2 T-180 - Sensible Car (Ex TSB Bank)

Offline TDi90

  • Posts: 2712
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Rolly - Under Construction...
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #13 on: December 06, 2007, 23:13:18 »
Quote from: "auf_wiedersehen_pet"
Next steps........

Goal Seek?
Conditional Formatting?
Look Up Tables?

 :twisted:  :twisted:  :twisted:


i can do those... apart from goal seek....never heard of that  :?
Rob
Logged
TDi90
~The DFYTR Moderation Team~

Offline Disco Matt

  • Posts: 2666
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +1/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #14 on: December 06, 2007, 23:33:35 »
Quote from: "fasthands"
It feels great to be liberated from Windows, it's Overpriced rubbish!!!
And I feel like a computer buff,  Yea!!! :lol:  :lol:  :lol:


It is good, isn't it? I've seen Linux improve dramatically in the last few years. I bought a copy of Red Hat (you pay for the disks and manuals) ages ago, it was pretty dire, but then I went over to Mandriva in '06. Upgraded to '07, still no problems, now I'm trying to find the time to go to '08 (takes a while to install and configure). Hopefully my floppy disk drive will work again with the new version...
Logged
1996 Discovery 300TDI. She's got it where it counts...

Offline mike142sl

  • Posts: 750
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #15 on: December 07, 2007, 09:56:54 »
Quote from: "Skibum346"
Rubbish!  :shock:
Well that told me then  :? - you have such a way with words.
Logged
Mike
Disco TD5 Landmark
SYM GTS250i Voyager
Swift Challenger 490

Offline Skibum346

  • Posts: 1975
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • T. A. N. S. T. A. A. F. L.
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #16 on: December 07, 2007, 10:14:45 »
Quote from: "mike142sl"
Quote from: "Skibum346"
Rubbish!  :shock:
Well that told me then  :? - you have such a way with words.


 :oops:  :wink:  :lol:

No offence meant... enthuisiasm getting the better of me...

I'm sorry... :smack:
Logged

Offline Steve ray

  • Posts: 893
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #17 on: December 09, 2007, 12:34:45 »
Quote from: "Skibum346"
Quote from: "mike142sl"
Quote from: "Skibum346"
Rubbish!  :shock:
Well that told me then  :? - you have such a way with words.


 :oops:  :wink:  :lol:

No offence meant... enthuisiasm getting the better of me...

I'm sorry... :smack:


Spot on Ski !
Logged
Sponsor us for the 2010 MAC 4x4 UK Challenge (5-7 March) www.justgiving.com/teambofa4x42011

Offline Steve ray

  • Posts: 893
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #18 on: December 09, 2007, 12:37:48 »
Quote from: "TDi90"
i can do those... apart from goal seek....never heard of that  :?
Rob


"Goal seek" is usually used in a spreadsheet with multiple variables to do sensitivity analysis e.g.

maybe to vary something like interest rate to meet a certain level of profitability. You'd say set profitability to the required %age, by changing the variable "interest rate".

Goal seek should then find an answer for you!
Logged
Sponsor us for the 2010 MAC 4x4 UK Challenge (5-7 March) www.justgiving.com/teambofa4x42011

Offline narked

  • Posts: 450
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #19 on: December 09, 2007, 13:05:27 »
Ah Linux, certainly has improved recently. I remember the first time I had a go at using Mandrake, must be nearly 8 years ago. Actually downloaded the 2 isos on my 56k dialup connection! Then there were the joys of trying to get it up and running, main problems were with the onboard graphics and sound. And of course no internet, as it was a winmodem!

Tried Ubuntu about 18 months ago I think, and things have certainly improved since my first forays! Installation is a much simpler process these days, and the amount of supported hardware has vastly increased.
Logged


Powys 4x4 Response

Current Mods:
Moonraker Minor CB radio
Safari Snorkel
Extended axle and transmission breathers
235/70R16 Insa Turbo Dakar M/Ts
Roof light bar with 4x Ring Road Runner lamps

pux

  • Guest
i never thought i would ask this.... (excel help)
« Reply #20 on: December 09, 2007, 13:14:23 »
bunch of computer geeks...........







why thank you my coat :lol:
Logged

Offline Steve ray

  • Posts: 893
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #21 on: December 09, 2007, 15:02:01 »
Quote from: "pux146"
bunch of computer geeks...........







why thank you my coat :lol:


armour-piercing rounds anyone ? ? ?  :wink:  :lol:  :lol:
Logged
Sponsor us for the 2010 MAC 4x4 UK Challenge (5-7 March) www.justgiving.com/teambofa4x42011

Offline clbarclay

  • Posts: 1615
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #22 on: December 09, 2007, 22:57:08 »
Whats his coat made from :?
Logged
Chris

Various range rovers from 1986 to 1988 in various states
Locost sports car based on mk2 escort - currently working on brakes, fuel and wiring

Offline Steve ray

  • Posts: 893
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #23 on: December 10, 2007, 18:59:13 »
Quote from: "clbarclay"
Whats his coat made from :?


knowing Mr PUXLEY it'll be the bullet proof type  :twisted:
Logged
Sponsor us for the 2010 MAC 4x4 UK Challenge (5-7 March) www.justgiving.com/teambofa4x42011

Offline Skibum346

  • Posts: 1975
  • Attack: 100
    Defense: 100
    Attack Member
  • Karma: +0/-0
  • T. A. N. S. T. A. A. F. L.
  • Referrals: 0
i never thought i would ask this.... (excel help)
« Reply #24 on: December 11, 2007, 11:20:57 »
Quote from: "Steve ray"
Quote from: "clbarclay"
Whats his coat made from :?


knowing Mr PUXLEY it'll be the bullet proof type  :twisted:


"Gunner, load sabot!"

"Sabot up!"

"Target, 200, coat, leaving forum"

"ON!!"

"Fire"

Kerrrrboooommmmm!!!!!!!!!

"Target destroyed"

 :(biglaugh):
Logged
Pages: [1]   Go Up
 





SimplePortal 2.3.5 © 2008-2012, SimplePortal