|
Help with formula
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 |
Help with formula
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 |
| All times are GMT +1. The time now is 07:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com