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