Rounding+Down+in+Excel

Rounding Down in Excel

Excel has a problem in that it rounds up for e.g. £110.576 should be returned as £110.57

To achieve this you have to use two (2) columns.

If your value is in D4, in another cell i.e. E4 type the formulae [without the quotes ] “ =Rounddown(D4,2) “ Enter

If your copy of Excel does not have Rounddown you can acquire it from Excel Analysis Toolpack

Choose the decimal places you require obviously 2 for currency, which is the second parameter in the equation

You can make the width of D column Ǿ zero then you do not see the lengthy result