ExcelBanter - Roundup to nearest $.0.05 Help

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

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

- - Roundup to nearest $.0.05 Help (https://www.excelbanter.com/excel-discussion-misc-queries/217943-roundup-nearest-%24-0-05-help.html)

Brad

Roundup to nearest $.0.05 Help

What the formula to roundup to nearest nickel.
example
$1.02 needs to be $1.05
$1.08 needs to be $1.10

thnaks
Brad

muddan madhu

Roundup to nearest $.0.05 Help

try this

=CEILING(A1,0.05)

On Jan 27, 1:02*am, Brad wrote:
What the formula to roundup to nearest nickel.
example
$1.02 needs to be $1.05
$1.08 needs to be $1.10

thnaks
Brad

Brad

Roundup to nearest $.0.05 Help

thank you!

"muddan madhu" wrote:

try this

=CEILING(A1,0.05)

On Jan 27, 1:02 am, Brad wrote:
What the formula to roundup to nearest nickel.
example
$1.02 needs to be $1.05
$1.08 needs to be $1.10

thnaks
Brad

All times are GMT +1. The time now is 05:46 PM.