Can a formula be set up to round to the nearest nickel?

[SW]

I am taking a specific cell, mulitiplying by 10% adding together, and the
outcome I want to be rounded to the nearest nickel.

[Jim May]

=CEILING(A3*$B$1,0.05) Displays .85
or
=FLOOR(A3*$B$1,0.05) Displays .80

where your cell A3 = .75
and Cell B1 = 1.10 and actual result is .825

HTH


"SW" wrote:

> I am taking a specific cell, mulitiplying by 10% adding together, and the
> outcome I want to be rounded to the nearest nickel.
>

[Bob Phillips]

=ROUND(A1*110%,2)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"SW" <SW@discussions.microsoft.com> wrote in message
news:2F3CB332-4597-4598-9D6D-419DEA081BDE@microsoft.com...
> I am taking a specific cell, mulitiplying by 10% adding together, and the
> outcome I want to be rounded to the nearest nickel.
>