ExcelBanter - Round number to whole No 25

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Round number to whole No 25 (https://www.excelbanter.com/excel-discussion-misc-queries/234281-round-number-whole-no-25-a.html)

lahaina

Round number to whole No 25

How do you round a number to the nearest $25?

Jim Thomlinson

Round number to whole No 25

My personal preference as it does not require the Analysis Toolpack is this...

=round(A1/25, 0) * 25

Where the number to be rounded is in A1
--
HTH...

Jim Thomlinson

"lahaina" wrote:

How do you round a number to the nearest $25?

All times are GMT +1. The time now is 04:00 AM.