Formula Help

[srcurrie]

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.

 

[Sbirro Cornuto]

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

 

[srcurrie]

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

 

[Sbirro Cornuto]

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?

 

[srcurrie]

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)

 

[Sbirro Cornuto]

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...

 

[Sbirro Cornuto]

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

 

[Sbirro Cornuto]

Well, did that do it for you or not?

 

[srcurrie]

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