no rounding
 

=((((F54) /1000) / 8.209) / 0.002205)

What do I need to add to this so that it doesn't round? For example 13.61706
returns 13.6171.

Thanks!!!
--
www.Marzetti.com

no rounding
 

Increase the numbers of decimals shown via the button in the formatting
toolbar that shows an arrow pointing to the left with a bunch of zeroes.

Note that XL is precise to 15 digits, so if you get an irrational number as
a result at some point XL will round whether you want it to or not.

Dave
--
Brevity is the soul of wit.


"JohnLute" wrote:

=((((F54) /1000) / 8.209) / 0.002205)

What do I need to add to this so that it doesn't round? For example 13.61706
returns 13.6171.

Thanks!!!
--
www.Marzetti.com

no rounding
 

More information is needed. What is in F54? How is this cell formatted (#
decimials, font, font size, etc)? What is the column width?

If F54 contains 246.4802924157, then this formula will return exactly
13.61706, and Excel will display the 5th decimal place (for 10pt Arial font)
provided that the column width is at least 8 (default is 8.43).

Note that formatting does not change the underlying value, so that even if
Excel only displays 4 decimal places, it will calculate with full precision.

Jerry

"JohnLute" wrote:

=((((F54) /1000) / 8.209) / 0.002205)

What do I need to add to this so that it doesn't round? For example 13.61706
returns 13.6171.

Thanks!!!
--
www.Marzetti.com

no rounding
 

"Jerry W. Lewis" wrote:

More information is needed. What is in F54?

=(D54)*16.5354

How is this cell formatted

General. 8 font. Sans Serif.

What is the column width?

6.57 pixels

Hope that helps. I suppose the function in F54 is creating issues?