Drop down list and if function

%3CLINGO-SUB%20id%3D%22lingo-sub-2400068%22%20slang%3D%22en-US%22%3EDrop%20down%20list%20and%20if%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2400068%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2F%20evening%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20link%20drop%20down%20list%20to%20if%20function%20for%20the%20following%20scenario%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20a%20separating%20employee%2C%20I%20was%20able%20to%20creat%20a%20drop%20down%20list%20that%20shows%20service%20duration%20in%20days%2C%20months%2C%20years.%20But%2C%20when%20i%20tried%20to%20make%20calculations%20of%20the%20duration%20dependent%20on%20the%20selected%20entry%20using%20if%20function%2C%20it%20did%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20about%20dateif%20function%20and%20so%2C%20but%20I%20want%20to%20see%20how%20my%20idea%20can%20be%20applied.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2400068%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2400209%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20list%20and%20if%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2400209%22%20slang%3D%22en-US%22%3EIf%20possible%20then%20please%20share%20the%20Workbook%20with%20us%2C%2C%20help%20me%20%26amp%3B%20others%20to%20test%20our%20methods%20with%20genuine%20data%20set%20to%20attain%20correct%20solution%20!!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Good morning/ evening,

 

I am trying to link drop down list to if function for the following scenario:

 

For a separating employee, I was able to creat a drop down list that shows service duration in days, months, years. But, when i tried to make calculations of the duration dependent on the selected entry using if function, it did not work.

 

I know about dateif function and so, but I want to see how my idea can be applied.

 

Appreciate your help

1 Reply
If possible then please share the Workbook with us,, help me & others to test our methods with genuine data set to attain correct solution !!