Too Many Decimal Places In Formula

I am horrible at writing formulas, but I needed a simple formula that would calculate gross tons per day using annual tons produced (O82)and actual operating days (O86).

This formula works, but generates 12 decimal places, which I do not want.

="Gross: "&O82/O86

returns:

Gross: 423.499555555556

How can I get the fomula to return 1-2 decimal places?

Hi, Rick. Try:

="Gross: "&ROUND(O82/O86,2)

or

="Gross: "&TEXT(O82/O86,"0.00")

HTH

Jason

That was the fastest response I have ever received. Thank you.

The first formula looks to be what I need, but it gives 2 decimal places in one cell, and 1 another.

(I have the exact same formula for Net Tons and Gross Tons.)

The formatting appears identical.

Even more odd...

="Gross: "&ROUND(O82/O86,2) returns 1 decimal place;
="Gross: "&ROUND(O82/O86,3) returns 1 decimal place;
="Gross: "&ROUND(O82/O86,4) returns 4 decimal places;
="Gross: "&ROUND(O82/O86,5) returns 5 decimal places;
="Gross: "&ROUND(O82/O86,6) returns 6 decimal places;
="Gross: "&ROUND(O82/O86,7) returns 7 decimal places; etc...

Rick,

The 2nd option I posted above will not round, but it will always show 2 decimal places.

If you want to round it to 2 decimal places, then you can incorporate both functions I used above:

="Gross: "&TEXT(ROUND(O82/O86,2),"0.00")

HTH

Jason

Thanks! That works great.