Formula Help

srcurrie · Mar 20th, 2002, 06:55 AM

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 · Mar 20th, 2002, 07:01 AM

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

srcurrie · Mar 20th, 2002, 08:13 AM

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 · Mar 20th, 2002, 08:31 AM

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 · Mar 20th, 2002, 09:22 AM

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 · Mar 20th, 2002, 09:32 AM

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 · Mar 20th, 2002, 10:07 AM

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 · Mar 21st, 2002, 02:01 AM

Well, did that do it for you or not?

srcurrie · Mar 21st, 2002, 09:31 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 06:55 AM	#1
srcurrie New Member Join Date: Mar 2002 Posts: 18	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.

Mar 20th, 2002, 07:01 AM	#2
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	What is your problem excatly? Could you run it by me one more time?

Mar 20th, 2002, 08:13 AM	#3
srcurrie New Member Join Date: Mar 2002 Posts: 18	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

Mar 20th, 2002, 08:31 AM	#4
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	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?

Mar 20th, 2002, 09:22 AM	#5
srcurrie New Member Join Date: Mar 2002 Posts: 18	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)

Mar 20th, 2002, 09:32 AM	#6
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	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...

Mar 20th, 2002, 10:07 AM	#7
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	Here goes: =CEILING(((RC[-1]RC[-3])/RC[-5]); 1) or =CEILING(((F1D1)/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 ]

Mar 21st, 2002, 02:01 AM	#8
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	Well, did that do it for you or not?

Mar 21st, 2002, 09:31 AM	#9
srcurrie New Member Join Date: Mar 2002 Posts: 18	Thanks it worked, I just tweaked it a bit. The understanding was very close.