I have been working on this for two days now, and frustration is finally setting in.
This is what I am trying to accomplish: each person in my group receives a specific amount of money depending on the number of years they have been in the group (longevity). In my description, the number of years is X.
If X is less than 5, receive nothing
If X is greater than or equal to 5, receive $700
If X is greater than or equal to 7, receive $900
If X is greater than or equal to 10, receive $1000
If X is greater than or equal to 15, receive $1100
If X is greater than or equal to 20, receive $1200
I'm trying ones that end up looking something like this:
=IF(A1>=5,"700",""),IF(A1<=6,"900",IF(A1>=9,"1000") etc. (Doesn't work)
Anyone have any ideas for me?
Please help!
Bookmarks