What fomula will tell me if the values in column B(DIFF) fall into one of these categoires, Between 0.00 and 0.25 is .25, Between 0.251 and 0.50 is .50. Between 0.51 and 0.75 is .75. Greater than 0.751 is 1.00
ST Diff
Indiana 0.50
Ohio 1.05
Ohio 1.00
Ohio 0.25
Thank you