T Tire Guy Jan 13, 2009 #1 I'm preparing a business price list. It reads a cell from my working cost sheets. On the price page can I round prices to end in .95?
I'm preparing a business price list. It reads a cell from my working cost sheets. On the price page can I round prices to end in .95?
J JBeaucaire Jan 13, 2009 #3 You don't really give enough info, so I will assume you want whatever price is in cell A1 to round to the NEAREST X.95. That formula would be: =ROUND(A1,0)-0.05 To always round UP to the next X.95, try: =CEILING(A1,1)-0.05
You don't really give enough info, so I will assume you want whatever price is in cell A1 to round to the NEAREST X.95. That formula would be: =ROUND(A1,0)-0.05 To always round UP to the next X.95, try: =CEILING(A1,1)-0.05
