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

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" wrote
in message ...

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

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.


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

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

Replace@mailinator with @tiscali.co.uk

"Jessi0198" wrote
in message ...

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.


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