Stop rounding

[rawdata89]

Hello, I want to display a number (1.785) to the 3rd decimal place without rounding however the formula is being rounded to 1.786 and I dont want to display 4 decimal places or round the other numbers, can anyone assist?

1.714​	0.75​	1.2855​
2​	0.25​	0.5​
		1.7855​	<---Excel	1.786​	<--Rounded

 

[kweaver]

Try this:

[c.ode]=INT(C3*1000)/1000[/code]

 

[fjns]

Hi, another option
=ROUND(C3,3)

 

[kweaver]

Hi, another option
=ROUND(C3,3)

That rounds which the OP doesn't want to happen.

 

[lrobbo314]

Could do

TRUNC(C3,3)

I believe.

 

[kweaver]

Could do

TRUNC(C3,3)

I believe.

Good one...I forgot about trunc and did it the hard way.

 

[fjns]

Sorry, the previous formula is wrong, but this is really another option
=ROUNDDOWN(C3,3)

 

[rawdata89]

Could do

TRUNC(C3,3)

I believe.

how can I include this in my formula? I would like to put this in the same cell as my overall score (d14). The 2 scores are weighted and create the overall score which I need it to read 3 decimal places without the rounding which should be 1.785 but is being rounded to 1.786

 

[kweaver]

try:

=TRUNC(D2*0.75+D7*0.25,3)

 

[rawdata89]

=TRUNC(D2*0.75+D7*0.25,3)

YOU ARE A LIFESAVER!!! THIS IS IT Thank you!!!!