Anyone here bit of an Ecel spreadsheet geek??? Help req'd...

how do you do those auto calcs??

I have about 200 numbers igoing down n column L, and i need to take 19% off each figure and put the result in the correspodning cell going down in column O.

Posted By: Cheltenham_Canary on October 21st 2009 at 12:43:38

Message Thread

Anyone here bit of an Ecel spreadsheet geek??? Help req'd... (General Chat) - Cheltenham_Canary, Oct 21, 12:43:38
- seemples (General Chat) - Tony Martin, Oct 21, 13:48:49
- fx=3 + 2 on the column, the fill down. (General Chat) - malkybarkid, Oct 21, 12:51:57
  - Well why answer then if you don't know? Unbelieveable, some people. (General Chat) - jafski, Oct 21, 13:10:06
    - I always find it best to at least 'have a go'. Where would we be if we all just gave up at (General Chat) - malkybarkid, Oct 21, 13:20:25
      - duh, it's Bristol (General Chat) - Ralf Scrampton, Oct 21, 13:22:42
      - ^^ That's what Bryan Gunn thought. Look where that got us. (General Chat) - jafski, Oct 21, 13:22:35
        
        You gave him your rebate, you helped him be King of Norwich City (n/m) (General Chat) - malkybarkid, Oct 21, 13:25:51
        
        yes (General Chat) - camcan, Oct 21, 13:29:41
        
        It's Gunn's team anyway. We'd be top if he was still here. (n/m) (General Chat) - jafski, Oct 21, 13:31:22
        
        I'm not sure we would. (n/m) (General Chat) - malkybarkid, Oct 21, 13:36:28
        
        Defo. With his grasp of tactics and substitutions we'd be sailing away. Fucking disgrace. (n/m) (General Chat) - jafski, Oct 21, 13:37:49
        
        Good job me and the rest of the true supporters did. One Grant Holt. (General Chat) - jafski, Oct 21, 13:28:08
        
        Did the malkster claim his rebate? (General Chat) - Old Git, Oct 21, 13:31:48
        
        Yes he did. The small time penny pincher. Boo I say, Booooooo. (n/m) (General Chat) - jafski, Oct 21, 13:32:46
        
        Well he's never ever to cheer a Grant Holt ghoul ever again (General Chat) - Old Git, Oct 21, 13:34:45
        
        Did the unclaimed rebate pay for Holt? (n/m) (General Chat) - malkybarkid, Oct 21, 13:44:17
        
        Dunno, but it's become a Wrath FACT, ask jafski, she'll tell you (n/m) (General Chat) - Old Git, Oct 21, 13:47:41
        
        Yes. Gunny said so. Super Bryan Gunn. Lambert out! (n/m) (General Chat) - jafski, Oct 21, 13:46:45
        
        fungibility (n/m) (General Chat) - malkybarkid, Oct 21, 13:47:34
        
        Gunngibility more like. Super Bryan Gunn. He's not bitter. (n/m) (General Chat) - jafski, Oct 21, 13:49:36
        
        ... (General Chat) - malkybarkid, Oct 21, 13:53:05
        
        Oh my god. That second group. There are people who really think that. (General Chat) - jafski, Oct 21, 13:56:44
        
        Has Cody written you his letter thanking you for his new Merc yet? (General Chat) - camcan, Oct 21, 13:37:42
        
        would either of them have not been paid were it not for the rebate? (n/m) (General Chat) - Ralf Scrampton, Oct 21, 13:44:42
        
        Cammers. No matter how hard you try, you are still not allowed to look at Grant Holt. (n/m) (General Chat) - jafski, Oct 21, 13:40:16
        
        Wot, not even at his shorts? Harsh (n/m) (General Chat) - Old Git, Oct 21, 13:42:11
        
        I like his smile (General Chat) - camcan, Oct 21, 13:54:19
        
        Curiously enough, I absolutely agree with you (n/m) (General Chat) - Old Git, Oct 21, 13:55:26
        
        of the current team (General Chat) - camcan, Oct 21, 14:12:10
        
        he always looks at me (General Chat) - camcan, Oct 21, 13:41:37
        
        Yes, he looks at you thinking. "She's one of them who didn't pay for me. Her, up there." (n/m) (General Chat) - jafski, Oct 21, 13:46:02
        
        "She's enjoying me for free, it's a disgrace. Look at her ogling my lunchbox." (n/m) (General Chat) - Old Git, Oct 21, 13:50:38
        
        he's thinking (General Chat) - camcan, Oct 21, 13:52:31
        
        Does Curo really have an Aston? (General Chat) - Old Git, Oct 21, 13:39:45
        
        apparently so (General Chat) - camcan, Oct 21, 13:41:23
        
        I know. Brand spanker. The little twunt. (n/m) (General Chat) - jafski, Oct 21, 13:41:04
        
        Hear, hear. No knee slides for the massrebaters. (n/m) (General Chat) - jafski, Oct 21, 13:37:00
- do the first one then fill down. Will change the formula on each line. (n/m) (General Chat) - megson, Oct 21, 12:47:27
  - Oh hang on, is it a rolling total as you go? Or just 19% off L in O? (n/m) (General Chat) - megson, Oct 21, 12:48:01
    - example....... (General Chat) - Cheltenham_Canary, Oct 21, 12:51:26
      - =L138-(L138*0.19) (General Chat) - Ralf Scrampton, Oct 21, 12:55:25
        
        Brillers, muchos ta's (General Chat) - Cheltenham_Canary, Oct 21, 13:03:14
        
        (i have seen this ^^^, i'm just choosing to ignore it) (n/m) (General Chat) - Ralf Scrampton, Oct 21, 13:17:49
        
        ^^^^^^^^ that'll do you nicely chelts (General Chat) - megson, Oct 21, 13:02:24
        
        yeah cheers ears! (n/m) (General Chat) - Cheltenham_Canary, Oct 21, 13:04:14
- Excel, that is!!! (n/m) (General Chat) - Cheltenham_Canary, Oct 21, 12:43:55

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.