I have a very limited but hopefully expanding knowledge using Excel 2013, so please forgive me if I don't understand your reply lol. I'm working with a scorecard to rank salespersons throughout our company & let them know where they stand vs our other locations. I've been using a function like this =IF(_LOC1>0, RANK(O4,O$4:O$33,0), " ") to rank them. It's worked out very well until today. We ran into a snag & I realized that when a salesperson's sold total was negative, Excel was treating it as a positive value & ranked him first. Does anyone know how I can change this formula to make it recognize the (-) on a value? Or do I just need to remember to manually change the negative values & do the math myself? Thank you!!!