SOLVED

Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2809162%22%20slang%3D%22en-US%22%3EFormula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2809162%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%26nbsp%3B%20have%20a%20time%20off%20tracker%20created%20in%20excel%20where%20I%20am%20trying%20to%20get%20a%20formula%20going%20to%20capture%20the%20follwing%20in%20once%20cell%3A%3C%2FP%3E%3CUL%3E%3CLI%3Eif%20employee%20has%20less%202%20years%20will%20receive%2040%20hours%3C%2FLI%3E%3CLI%3Eif%20employee%20has%202-5%20years%20will%20receive%2080%20hours%3C%2FLI%3E%3CLI%3Eif%20employee%20has%20more%20than%205%20years%20will%20receive%20120%20h%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2809162%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2809192%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2809192%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1172722%22%20target%3D%22_blank%22%3E%40Norma730%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20the%20number%20of%20years%20is%20in%20F2.%20In%20another%20cell%20in%20row%202%2C%20enter%20the%20formula%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D40*(1%2B(F2%26gt%3B%3D2)%2B(F2%26gt%3B%3D5))%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20can%20be%20filled%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello All!

 

I  have a time off tracker created in excel where I am trying to get a formula going to capture the follwing in once cell:

  • if employee has less 2 years will receive 40 hours
  • if employee has 2-5 years will receive 80 hours
  • if employee has more than 5 years will receive 120 h
2 Replies

@Norma730 

Let's say the number of years is in F2. In another cell in row 2, enter the formula

 

=40*(1+(F2>=2)+(F2>=5))

 

This can be filled down.

best response confirmed by Norma730 (New Contributor)
Solution
you are the best!!

Thank you Hans!