Rounding currency.

[Jessi0198]

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.

 

[RagDyer]

I can't see what your formula actually does, but guessing at it, does this
work for you:

=ROUND((SUM(E:E)*1.1)/0.05,0)*0.05
??
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Jessi0198]

that didn't work. This is what the formula does:
column E is $10.75. I need to add 10%. So using the following:
=SUM(E:E*0.1+E:E), I get $11.83, but I want it to round to $11.85.

 

[Sandy Mann]

I assume that your formula is in the same row as the value in Column E. In
that case you don't need to use E:E or SUM. With the value in E3 try:
=ROUND((E3*1.1)*20,0)/20 and copy down.

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk