Help with formula

R

Richard

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
 
T

Tyro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top