Can I round to the nearest nickel@

Can I round to the nearest nickel@

Post by Stev » Fri, 06 Aug 2004 23:40:59


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

Can I round to the nearest nickel@

Post by Peo Sjoblo » Fri, 06 Aug 2004 23:47:53

=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)

 
 
 

Can I round to the nearest nickel@

Post by CoRrRa » Fri, 06 Aug 2004 23:51:13

"Steve" < XXXX@XXXXX.COM > wrote in



=ROUND(A1/0.05;0)*0.05

Any good?

CoRrRan