Home

Excel does not round up on 5

%3CLINGO-SUB%20id%3D%22lingo-sub-820994%22%20slang%3D%22en-US%22%3EExcel%20does%20not%20round%20up%20on%205%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-820994%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%20on%20the%20day.%20I%20have%20found%20that%20excel%20does%20not%20round%20up%20on%205.%20Surely%20this%20is%20some%20option%20that%20is%20changeable.%20For%20example%20if%20a%20value%20is%200.75%2C%20changing%20the%20number%20of%20decimal%20places%20to%201%2C%20results%20in%200.7%20instead%20of%20the%20correct%200.8.%20Is%20there%20some%20way%20to%20fix%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-820994%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Erounding%20up%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-821149%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20does%20not%20round%20up%20on%205%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821149%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397643%22%20target%3D%22_blank%22%3E%40EM616%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20check%20this%20(A1%20is%20input%20cell)%3C%2FP%3E%3CP%3E%3DMROUND(A1%2C%200.1)%3C%2FP%3E%3CP%3Ehope%20it%20helps!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-821153%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20does%20not%20round%20up%20on%205%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821153%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397643%22%20target%3D%22_blank%22%3E%40EM616%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat's%20the%20function%20you%20use%3F%3C%2FP%3E%3CP%3EThe%20round%20result%20depends%20on%20the%20function!%3C%2FP%3E%3CP%3EIf%20you%20use%20%3CSTRONG%3EROUND(0.75%2C1)%3C%2FSTRONG%3Eor%20%3CSTRONG%3EROUNDUP(0.75%2C1)%3C%2FSTRONG%3Eit%20should%20works!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%2C%20the%20real%20number%20in%20the%20cell%20isn't%20exactly%200.75!%3C%2FP%3E%3CP%3EMaybe%20it's%200.745.%3C%2FP%3E%3CP%3ETo%20check%20that%2C%20select%20the%20cell%2C%20and%20press%20Increase%20Decimal%20button%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128341iB0BB42DE535BFD22%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Increase%20Decimals.png%22%20title%3D%22Increase%20Decimals.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
EM616
Occasional Visitor

Greetings on the day. I have found that excel does not round up on 5. Surely this is some option that is changeable. For example if a value is 0.75, changing the number of decimal places to 1, results in 0.7 instead of the correct 0.8. Is there some way to fix this?

2 Replies

@EM616 

please check this (A1 is input cell)

=MROUND(A1, 0.1)

hope it helps!! 

Highlighted

@EM616

 

Hi,

 

What's the function you use?

The round result depends on the function!

If you use ROUND(0.75,1) or ROUNDUP(0.75,1) it should works!

 

Perhaps, the real number in the cell isn't exactly 0.75!

Maybe it's 0.745.

To check that, select the cell, and press Increase Decimal button:

Increase Decimals.png

Related Conversations
Transferring long tables to Word?
laonglaan in Excel on
1 Replies
Erro ao abrir a planilha
amauripaulo1978 in Excel on
0 Replies
Problem Determining Specific Dates with Formulas
TraderRef in Excel on
2 Replies
Pivot table with dates
Vinay1960 in Excel on
2 Replies
rusty on ms excel formulas, please help...
saj1011 in Excel on
1 Replies
Help with Formula
Machala Sentance in Excel on
5 Replies