J Jag New Member Aug 13, 2014 #1 Hi How do I round down to the nearest 2 decimal 5 cents. eg. 26.533 to 26.50 32.49 to 32.45 46.981 to 46.95 15.025 to 15.00 As I need to bill the vendor , I can only round down to the nearest 5 cents.
Hi How do I round down to the nearest 2 decimal 5 cents. eg. 26.533 to 26.50 32.49 to 32.45 46.981 to 46.95 15.025 to 15.00 As I need to bill the vendor , I can only round down to the nearest 5 cents.
J Jag New Member Aug 13, 2014 #3 Nope it does not work eg 60.369 it shows 60.30 instead of the required 60.35 (down to nearest 5 cents) 46.981 it shows 46.9 instead of 46.95
Nope it does not work eg 60.369 it shows 60.30 instead of the required 60.35 (down to nearest 5 cents) 46.981 it shows 46.9 instead of 46.95
Somendra Misra Excel Ninja Aug 13, 2014 #4 Hi Jag, Try =FLOOR(A1,0.05) A1 is ref of cell with number. Regards,