• 585K Members
• 13K Online
• 708K Conversations
SOLVED

## Which formula to use

Highlighted
Occasional Contributor

# Which formula to use

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

# Re: Which formula to use

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

# Re: Which formula to use

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