ExcelBanter - I am trying to round up to the nearest 25 cents

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - I am trying to round up to the nearest 25 cents (https://www.excelbanter.com/new-users-excel/23500-i-am-trying-round-up-nearest-25-cents.html)

sypher

I am trying to round up to the nearest 25 cents

I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP

JE McGimpsey

Try

=CEILING(A1, 0.25)

In article ,
sypher wrote:

I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP

Bob Phillips

=ROUND(A1*4,0)/4

--
HTH

Bob Phillips

"sypher" wrote in message
...
I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP

All times are GMT +1. The time now is 06:39 AM.