rounding

[dodge]

how do I round a currency value to the nearest 5c. where
the cell may have a value that may require rounding up or
down depending on it's value. ie $1.11 to $1.10 or $1.14
to $1.15.

 

[Frank Kabel]

Hi
use
=ROUND(A1*20,0)/20

Also see:
http://www.xldynamic.com/source/xld.Rounding.html#fractions

 

[Ryan Poth]

Dodge,

Try:

=ROUND(A1*20,0)/20

HTH,
Ryan