Think so. 20 = 0.175 and 30 = whatever and 40 = whatever...

...I'm figuring if I put in 20 in one column and weight in another and then drag it down Excel will do the maths to 500 which I know equals 4.405. But I can't do that as I don't know what 30 = in kgs. Then i have to repeat process but this time in pounds...

Posted By: Dandy Highburyman on February 6th 2017 at 16:19:09

Message Thread

I hate Excel and maths need help post... (General Chat) - Dandy Highburyman, Feb 6, 15:58:03
- Lol (n/m) (General Chat) - essexcanaryOTBC, Feb 6, 19:08:09
- Does this link work......? (General Chat) - JD3, Feb 6, 16:18:56
  - So Ralph 30 = 0.2625? (n/m) (General Chat) - Dandy Highburyman, Feb 6, 16:24:26
    - Yes - i think we've both updated our tabs now! (General Chat) - JD3, Feb 6, 16:24:55
      - That's brilliant both - thanks... (General Chat) - Dandy Highburyman, Feb 6, 16:29:27
        
        if 500 is 4.405 then 20 is 0.1762 (i've updated sheet 2 to show) (n/m) (General Chat) - Ralf Scrampton, Feb 6, 16:32:50
        
        Thanks Ralf I've just listed it - cheers... (General Chat) - Dandy Highburyman, Feb 6, 16:39:13
        
        goes off to google what a lb is in kg (General Chat) - Ralf Scrampton, Feb 6, 16:48:14
        
        I don't know what that means. Apols (n/m) (General Chat) - Dandy Highburyman, Feb 6, 16:50:11
        
        Just seen you've worked it out. Thanks guv. Will now it handover to client for sign off... (General Chat) - Dandy Highburyman, Feb 6, 16:56:50
        
        hope it's right, don't really know if the lbs values make sense... (General Chat) - Ralf Scrampton, Feb 6, 16:59:41
        
        Ultimately the client should be supplying me the content... (General Chat) - Dandy Highburyman, Feb 6, 17:29:20
        
        👍 (n/m) (General Chat) - JD3, Feb 6, 20:28:22
        
        Because if 500 = 4.405, 20 doesn't equal 0.175! (It equals 4.405/500*20=0.1762) (n/m) (General Chat) - JD3, Feb 6, 16:32:34
        
        Client told me what £20 equals. They're a bank so nothing makes sense (n/m) (General Chat) - Dandy Highburyman, Feb 6, 16:40:12
      - yep this. when i did my copy and paste from desktop excel it took values not formulas (General Chat) - Ralf Scrampton, Feb 6, 16:26:36
  - Yes thanks... (General Chat) - Dandy Highburyman, Feb 6, 16:23:05
  - i like that, i've put mine in sheet 2 (n/m) (General Chat) - Ralf Scrampton, Feb 6, 16:21:19
- do you want to be able to change the values 20, 0.175kg and 30 and still have it work? (n/m) (General Chat) - Ralf Scrampton, Feb 6, 16:12:34
  - Think so. 20 = 0.175 and 30 = whatever and 40 = whatever... (General Chat) - Dandy Highburyman, Feb 6, 16:19:09
- Formula of =0.175x'Text Entry Cell Ref' in the box where you want your answer (n/m) (General Chat) - JD3, Feb 6, 16:03:30
  - Ignore me and see dwayne below! (0.175/20) obvs! (n/m) (General Chat) - JD3, Feb 6, 16:04:32
- cell=0.000875*cell (General Chat) - dwayne_dooley, Feb 6, 16:02:49
  - 0.000175 I mean (General Chat) - dwayne_dooley, Feb 6, 16:07:06
    - No, I was right first time (n/m) (General Chat) - dwayne_dooley, Feb 6, 16:09:04
- I used to do all that shit but have made myself forget since retirement and can't be arsed (General Chat) - CB41, Feb 6, 16:01:32

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.