How would you write your formula on paper? I have no idea what you want.
Explain it simply such as A+b*d-f

Tyro

"Richard" wrote in message
...

How would you write a formula to calculate the total hours in sheet1.
Thanks
in advance!! I'm trying to match whats on sheet2 with the part number on
sheet1. Example: Once RT-005 is entered on sheet1 it will automatically
calculate the hours on sheet1 using the information on sheet2
Sheet1
Part # Qty Needed Qty in Stock Hours
RT-005 70 100 ?

Sheet2
Part Number/ Ring Qty. / Qty. Per Ring /Tumblers Available/ Tumble Time in
Hours
RT-005 1 20 1
3