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.
0
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))))