View Single Post
  #1   Report Post  
Jessi0198
 
Posts: n/a
Default Rounding currency.


This is what I have in a column: =SUM(E:E*0.1+E:E)
What would I add to that calculation to have the figure rounded to the
nearest nickel.


--
Jessi0198
------------------------------------------------------------------------
Jessi0198's Profile: http://www.excelforum.com/member.php...o&userid=25158
View this thread: http://www.excelforum.com/showthread...hreadid=386562