Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Formula Help

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Looking for help...
    Need help on following:
    Example:
    Col A - This is a device number
    Col B - This is the amount of parts that fit in Col A
    Col C - This is part number
    Col D - This is the amount of spaces it will take from Col B
    Col E - Device that the said part is referenced to
    Col F - Planned amount of parts
    Col F - Devices that will be needed

    Sorry for the long winded example, but I have been at this for days to no avail.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What is your problem excatly? Could you run it by me one more time?

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to get this formula to work as shown.
    Columns A, B, C, D and E will be fixed information.
    Column F will be a manually entered amount of parts and by referencing Columns A thru E the correct number of devices will be placed in these cells.

    Thanks and if you can help feel free to email me at:
    srcurrie@mindspring.com


  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I still donīt get it 100%. Hereīs my understandings:

    Col A - This is a device number [ID of the device?]
    Col B - This is the amount of parts that fit in Col A
    Col C - This is part number [ID of the part?]
    Col D - This is the amount of spaces it will take from Col B [Spaces? What do you mean?]
    Col E - Device that the said part is referenced to [the desciption of the device?]
    Col F - Planned amount of parts
    Col F - Devices that will be needed [the descriptions of the devices?]

    Did I get something right here?

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Lets say..
    Col A is a square (I will name it Test)
    Col B is 4
    Col C is 1/4 of the square (I will call it ATest)
    Col D is 1
    Col E is a reference to Col A (Test)
    Col F is an entered amount of Col C which in turn references Col D (Lets say 6)
    Col G will automatically tell you 2 of Col A will be needed as it is more than 4)

    Columns A thru E are existing items
    Column F is an entered item
    Column G is the function in question


    A1 = Test
    B1 = 4
    C1 = Atest
    D1 = 1
    E1 = A1

    F1 = (Entered item)
    G1 = (Function)

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Okay, I got you. So it's the matter of simple mathematics...

    Give me a minute or two, I got to start up my Excel and give it a try...

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here goes:

    =CEILING(((RC[-1]*RC[-3])/RC[-5]); 1)

    or

    =CEILING(((F1*D1)/B1); 1)

    Try it and tell me if I totally misunderstood you?

    [ This Message was edited by: Sbirro Cornuto on 2002-03-21 01:46 ]

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Little Italy
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well, did that do it for you or not?

  9. #9
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks it worked, I just tweaked it a bit. The understanding was very close.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •