Why does "Accounting" round .15 to .1 and not .2?

[taylorsm]

Isn't it basic math that .5 should round up?

[mjr veverka]

some example (?) ... for example ...

[joeu2004]

When I use Accounting format with 1 decimal place, 123.15 rounds to 123.2 in Excel 2010.

My guess: what appears to be xxx.15 is really something less. Try formatting xxx.15 to 15 decimal places first.

PS.... If you would like what appears to be xxx.15 to round to xxx.2, a reliable way to do that is:

=ROUND(ROUND(A1,2),1)

[MrShorty]

Exactly what value is present? Is the value exactly 0.15, or is it something like 0.14999999? You are correct that 0.15000000 should round up to 0.2, but 0.149999999 will round down to 0.1 (and both 0.150000000 and 0.14999999 may display as 0.15). Look more closely at the value (extend decimal places, maybe) and determine exactly what value is stored in the cell.

[taylorsm]

0.15000000

when I expand the decimals out, this is what I get. Attached is the workbook specifically causing this question. Y18 is the cell.

[AliGW]

You haven't gone far enough:

Excel 2016 (Windows) 32 bit

	X	Y
15	Thursday	Friday
16	29/03/2018	30/03/2018
17	8.12	7.85
18	-	0.149999999999999000

Sheet: Basic w Breaks & 40 Overtime

[taylorsm]

OMG that is ridiculous! lol How do I make something like roll to the .2 then? Our software would require that to roll to .2

[AliGW]

You could apply ROUND to the formula that produces the result.

[taylorsm]

thanks! i'll do that

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.