Nested And/IF Statments

Solved/Closed
nelsojm Posts 2 Registration date Friday November 1, 2013 Status Member Last seen November 4, 2013 - Nov 1, 2013 at 04:23 PM
nelsojm Posts 2 Registration date Friday November 1, 2013 Status Member Last seen November 4, 2013 - Nov 4, 2013 at 01:49 PM
Hello and good day.

I am in the process of putting together an annual bonus/vacation accural sheet and need some assistance with building a complex function. Here is what is needing to occur.

In cell A1 is the number of years that a mariner has been employed
In cell A2, I need it to reference cell A1 and return a value of either 10 days, 15 days or 22 days based upon the below information.

1-4 years = 10
5-9 years = 15
10+ years = 22

Can this be done? I am attempting to do this with in 2013 and when I go to piece meal all the data, my system screams error.

Help???
Related:

2 responses

Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
Nov 2, 2013 at 10:01 AM
Hi nelsojm

Try the following LOOKUP function.

=LOOKUP(A1,{0,5,10},{10,15,22})

Or another alternative is the VLOOKUP.

https://www.contextures.com/excelvlookupexamples.html
nelsojm Posts 2 Registration date Friday November 1, 2013 Status Member Last seen November 4, 2013
Nov 4, 2013 at 01:49 PM
Thank you so much. This was much easier to use than IF statements.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 1, 2013 at 08:19 PM
try this
=IF(a1="","", if(a1>=10,22,if(a1>=5,15, if(a1>=1,10,0))))