Don't Round...

  • Thread starter Thread starter Michael Miazga
  • Start date Start date
M

Michael Miazga

How can I make Excel NOT round the numbers. For example I have a cell
that has a formula with a result of 4.3564, the cell is formatted as a
number with 2 decimals so that it displays 4.36. I want the cell to
display 4.35, don't round the number.
 
Try

=TRUNC(C3,2)


replace C3 with the formula that returns 4.3564 and format as general or
number
 
How can I make Excel NOT round the numbers. For example I have a cell
that has a formula with a result of 4.3564, the cell is formatted as a
number with 2 decimals so that it displays 4.36. I want the cell to
display 4.35, don't round the number.
Click to expand...

=trunc(formula, 2)

But read the TRUNC help page for an explanation of TRUNC() v. INT().
 
How can I make Excel NOT round the numbers. For example I have a cell
that has a formula with a result of 4.3564, the cell is formatted as a
number with 2 decimals so that it displays 4.36. I want the cell to
display 4.35, don't round the number.
Click to expand...

ROUNDDOWN(number,num_digits)

ed
 
Michael said:
How can I make Excel NOT round the numbers. For example I have a cell
that has a formula with a result of 4.3564, the cell is formatted as a
number with 2 decimals so that it displays 4.36. I want the cell to
display 4.35, don't round the number.
Click to expand...

I presume that you're not doing anything else with the number except
displaying it. If you are making further calculations with the truncated
number you may be introducing errors that you won't be aware of.

Bill
 
Back
Top