Can I round to the nearest nickel@

S

Steve

I would like to use the ROUND function to round a currency
number to the nearest nickel (0.05). Any examples?
 
P

Peo Sjoblom

=ROUND(B1/0.05,0)*0.05

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
C

CoRrRan

I would like to use the ROUND function to round a currency
number to the nearest nickel (0.05). Any examples?
Click to expand...

=ROUND(A1/0.05;0)*0.05

Any good?

CoRrRan
 
Top