Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency format | Excel Worksheet Functions | |||
Currency to Text | Excel Discussion (Misc queries) | |||
in mail merge how do i convert currency from excel to word | Excel Discussion (Misc queries) | |||
Currency Style button | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) |