Apr 05 2018
08:56 AM
- last edited on
Jul 25 2018
11:34 AM
by
TechCommunityAP
Apr 05 2018
08:56 AM
- last edited on
Jul 25 2018
11:34 AM
by
TechCommunityAP
Hello,
I am looking for a formula but I don't know which one to use.
What I would like to do is that when in collum material is entered 1804 that it multiplies the collum quantity with 34,3. And the result is shown in collum plan(hours). But if in collum material is entered 1800 that then it is multiplied with 17,2 and collum quantity and result again is shown in collum plan(hours). File is in the attatchment.
Can anyone tell me which formula would work for this?
Below my file:
Shift | Ordernumber | line | Material | Quantity | Plan(hours) | Reality(hours) | Operator | Comments | |||||
1 | 1992620 | 10 | 1804 | 100 | RH | ||||||||
1 | 1992621 | 20 | 1800 | 0 | |||||||||
2 | 156461 | 20 | 1800 | 100 | time per second | ||||||||
1804 | 34.3 | ||||||||||||
1800 | 17.2 | ||||||||||||
|
Apr 05 2018 09:10 AM
Solution