| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
