I have values in a worksheet that are from 175 - 260 and I want to but a score on them in a separate column (B).
values of >= 260 will be 50, 200-225 will be 45, 175-199 will be 40.
Here is my formula, and it is only putting a value in cells that have 260. everything else is getting 0's. :(...