I've never had issues setting min/max values in my charts. I don't have access to your specific dataset so I obviously can't test your exact formula and scenario. Number formatting has nothing to do with using floor or ceiling on your values, so I'm not sure how that came into play here.
