I am trying to take a percentage and for every .5 percent I want one point and I want it to round down, The catch is I want it to only start after 2.5%. Now I have two types of possibilities that are entered in texts. So for example you have a percentage of sales that you get points for. You dont get points unless you get over 2.5% and for every .5 percent you get 1 point. So 2.5-2.99 = 1 point, 3.0-3.49 = 2 points, ect. But if you have Server in a box you keep your value in points. If you have Bar you lose 5 points. Can anyone help with this equation?
I am thinking =IF(OR(d27="2.5 to 2.99"),"1",IF(OR(d27="3.0 to 3.49"),"2",IF(OR(d27="3.5 to3.99"))) to get started but how do i incorporate the Server or Bar Part?
I am thinking =IF(OR(d27="2.5 to 2.99"),"1",IF(OR(d27="3.0 to 3.49"),"2",IF(OR(d27="3.5 to3.99"))) to get started but how do i incorporate the Server or Bar Part?