SOLVED
Home

Which formula to use

Highlighted
Occasional Contributor

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  

 

                         
2 Replies
Highlighted
Solution
=E2*VLOOKUP(D2,$L$5:$M$6,2,FALSE)
Highlighted

Works like a charm thanks!

Related Conversations
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Leap year formula
Hattsoff in Excel on
4 Replies