ROUNDDOWN but calculate actual numbers

  • Thread starter Thread starter edwardpestian
  • Start date Start date
E

edwardpestian

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
 
You could have 2 columns of values, one with the actual values, and th
other with them rounded down.

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

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