# Formula Needed for Transit Time

*From*: Angela <Angela@xxxxxxxxxxxxxxxxxxxxxxxxx>*Date*: Tue, 9 Aug 2005 12:08:02 -0700

Good afternoon,

I have created a excel MRP for ordering raw material and I have listed below

the forumla I use, but I would like to add in the transit time which is 2 day.

Column E

F G

A244 BRACKET Order 10000 10000 5000

NF Usage 11090 9050 7000

2000 PER BOX Inventory 10000 8910 9860 7860

=ROUND((H131+I131+(J131*0.5)-G132)/2000,0)*2000

>From the formula I have above I take the inventory and order two and halfs

weeks ahead which has the box quantity listed so I order in even amounts, but

I really need to add the transit time, can someone help me with this addition

of transit time.

Thank you,

.

**Follow-Ups**:**Re: Formula Needed for Transit Time***From:*Dave O

- Prev by Date:
**Re: What does the "$" symbol do to a cell value in a formula.** - Next by Date:
**share a workbook but protect the formulas** - Previous by thread:
**... Count Function ... with any character ...** - Next by thread:
**Re: Formula Needed for Transit Time** - Index(es):