I am trying to solve for column N(Incentive Bonus) using data from column L(Days Completed)
If L is blank leave N Blank
If L is 0 to 30 = 500
If L is 31 to 45 = 250
If L is greater than 45 = 0
How can I put all of that into on formula?
Attached is an test Example.
Bookmarks