I am sure this is an easy fix, but I’m trying to figure what % someone would get base on years of service. I have then service years completed using YEARFRAC. So now 0-15 years gets a certain %, 16-25 years gets a different %, and 26+ gets different %. I am able to get the 0-15 to work, can kind of get the first part 16-25 to work. Problem is if service years are greater than 25, I cannot get the formula to max the cell to a specific number, the cell should display 10 if the service head is >25.