View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwardpestian
 
Posts: n/a
Default ROUNDDOWN but calculate actual numbers


Hi,

I'd like to use the rounddown function on range of cells in a
particular column. Not for any other reason but for viewing. I don't
need to see 917,248, but rather just 917,200. However, when summing
the range, I need the sum to calculate the actuals, not the rounddown
numbers.

Is this possible?

Thanks in advance.

EP


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=542027