FAO Lee or anyone else that's a whizz with Excel.

And I'm definately not looking at you Sellers.

How do you link a load of calculations into one big long one?

Basically I need to take a figure in dollars, convert to poundage at a fixed rate, add on a fixed delivery cost, add VAT, then add a fixed % mark up.

I can do the individual calculations, but when I try and do one big one my head keeps falling off.

Posted By: tudders on October 4th 2010 at 16:41:02

Message Thread

FAO Lee or anyone else that's a whizz with Excel. (General Chat) - tudders, Oct 4, 16:41:02
- This should work (General Chat) - lurd, Oct 4, 16:50:50
  - Cheers, I'll give that a go. (n/m) (General Chat) - tudders, Oct 4, 16:56:00
- actually why do you need to do all the calculations in one cell? (n/m) (General Chat) - Ralf Scrampton, Oct 4, 16:46:11
  - Just so that first cell shows net cost in $, and second shows gross price in ?, (General Chat) - tudders, Oct 4, 16:55:40
    - Hidden columns are your friend (General Chat) - lurd, Oct 4, 16:57:19
      - yeah, do this ^^^ (General Chat) - Ralf Scrampton, Oct 4, 17:15:31
      - I was just thinking that. (General Chat) - tudders, Oct 4, 17:00:41
        
        Locked in the BSG for a week. (n/m) (General Chat) - lurd, Oct 4, 17:09:23
  - was exactly question i was about to ask... (n/m) (General Chat) - Yellalee, Oct 4, 16:47:21
- use brackets and shit and just type it all out in one long formula intut (n/m) (General Chat) - Ralf Scrampton, Oct 4, 16:44:50
  - I tried that, (General Chat) - tudders, Oct 4, 16:45:49
    - Result then. (n/m) (General Chat) - megson, Oct 4, 16:56:47
- Even I can do that (General Chat) - Old Git, Oct 4, 16:43:29
- GIYLF (n/m) (General Chat) - selwyn, Oct 4, 16:42:31
  - FOYFC. (n/m) (General Chat) - tudders, Oct 4, 16:44:59
    - FOYTPFWER (n/m) (General Chat) - selwyn, Oct 4, 16:47:11
      - Lack of opposable thumbs fucked up your typing again, sellers? (n/m) (General Chat) - Yellalee, Oct 4, 16:50:22
        
        Do you type with your thumbs?? (General Chat) - Old Git, Oct 4, 16:53:19
        
        (shhhh - I don't think he spotted the fallacy in my post...) (n/m) (General Chat) - Yellalee, Oct 4, 16:54:01
        
        (I think I have got the all-clear) (n/m) (General Chat) - Yellalee, Oct 4, 16:57:32
        
        what was wrong with you? (n/m) (General Chat) - selwyn, Oct 4, 16:58:26
        
        fallacy? (n/m) (General Chat) - selwyn, Oct 4, 16:55:19
        
        From the words "phallus" and "see", thus "Whenever selwyn logs on you see a total phallus" (n/m) (General Chat) - Old Git, Oct 4, 16:59:08
        
        FOYFFW (: (n/m) (General Chat) - selwyn, Oct 4, 16:52:25
        
        I went on holiday there. Toll charge on the Severn is a bastard though. (n/m) (General Chat) - Yellalee, Oct 4, 16:53:04

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.