Dear All, How do I round to the nearest £5. For example if I have £201.37 I need this to show £200??
Dear All, How do I round to the nearest £5. For example if I have £201.37 I need this to show £200??
Try
=ROUND(A10/5,0)*5
If the value to be rounded is in cell A1 then in another cell put the formula:
=ROUND(A1/5,0)*5
Well, we seem to be in agreement![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks