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

ROUNDDOWN but calculate actual numbers
 

You could have 2 columns of values, one with the actual values, and the
other with them rounded down.

The rounded down values are visible but the actual values could be
hidden by right clicking on the column and clicking on Hide. When
finding the sum, base the formula on the hidden, actual values.

Alternatively, you could have the actual values on another hidden
worksheet and base your rounddown and sum functions on those values.
Values on the hidden sheet can be referenced using the syntax
=SheetName!CellAddress.


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