SOLVED

Rounding numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-1795029%22%20slang%3D%22en-US%22%3ERounding%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795029%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22j83agx80%20r8blr3vg%22%3E%3CDIV%20class%3D%22h9e7qa53%20l9j0dhe7%20hpfvmrgz%20lzcic4wl%22%3E%3CDIV%20class%3D%22ni8dbmo4%20stjgntxs%20ii04i59q%22%3E%3CDIV%20class%3D%22l60d2q6s%20d1544ag0%20sj5x9vvc%20tw6a2znq%20l9j0dhe7%20ni8dbmo4%20stjgntxs%20kdgqqoy6%20ihh4hy1g%20e72ty7fz%20qmr60zad%20jm1wdb64%20qv66sw1b%20ljqsnud1%20g6srhlxm%22%3E%3CDIV%20class%3D%22ljqsnud1%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22j83agx80%20r8blr3vg%22%3E%3CDIV%20class%3D%22pfnyh3mw%20ewlkfwdl%20j83agx80%20bp9cbjyn%20qnrpqo6b%20jxrgncrl%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22lzcic4wl%22%3E%3CDIV%20class%3D%22oajrlxb2%20gs1a9yip%20g5ia77u1%20mtkw9kbi%20tlpljxtp%20qensuy8j%20ppp5ayq2%20goun2846%20ccm00jje%20s44p3ltw%20mk2mc5f4%20rt8b4zig%20n8ej3o3l%20agehan2d%20sk4xxmp2%20rq0escxv%20nhd2j8a9%20j83agx80%20mg4g778l%20btwxx1t3%20pfnyh3mw%20p7hjln8o%20kvgmc6g5%20cxmmr5t8%20oygrvhab%20hcukyx3x%20tgvbjcpo%20hpfvmrgz%20jb3vyjys%20rz4wbd8a%20qt6c0cv9%20a8nywdso%20l9j0dhe7%20i1ao9s8h%20esuyzwwr%20f1sip0of%20du4w35lb%20lzcic4wl%20abiwlrkh%20p8dawk7l%20mkd47r93%20rgmg9uty%22%3E%3CDIV%20class%3D%22n00je7tq%20arfg74bv%20qs9ysxi8%20k77z8yql%20i09qtzwb%20n7fi1qx3%20b5wmifdl%20hzruof5a%20pmk7jnqg%20j9ispegn%20kr520xx4%20c5ndavph%20art1omkt%20ot9fgl3s%22%3E%3CP%3EHello.%20The%20question%20is%20how%20to%20force%20Excel%20to%20make%20calculations%20on%20numbers%20rounded%20to%202%20positions%20after%20decimal%20point%2C%20how%20it%20is%20used%20in%20accounting.%26nbsp%3BI%20mean%20to%20treat%20e.g.%201.2345%20as%201.23%20in%20further%20calculations.%3CBR%20%2F%3EI%20can%20use%20round%20function%20each%20time%20but%20is%20it%20possible%20to%20make%20Excel%20do%20it%20automatically%3F%3CBR%20%2F%3EI'd%20be%20obliged%20for%20help.%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1795029%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1795137%22%20slang%3D%22de-DE%22%3ESubject%3A%20Rounding%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795137%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F837504%22%20target%3D%22_blank%22%3E%40Tomasz_Scianowski%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DROUND(A1%3B2)%3C%2FP%3E%3CH1%20id%3D%22toc-hId-560720624%22%20id%3D%22toc-hId-560720625%22%20id%3D%22toc-hId-560720625%22%3ERound%20a%20number%20to%20the%20decimal%20places%20I%20want%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fworldwide%3FreturnURL%3Dhttps%253A%252F%252Fsupport.microsoft.com%252Fen-us%252Foffice%252Fround-a-number-to-the-decimal-places-i-want-49b936f9-6904-425d-aa98-02ffb7f9a17b%253Fui%253Den-us%2526rs%253Den-us%2526ad%253Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fworldwide%3FreturnURL%3Dhttps%253A%252F%252Fsupport.microsoft.com%252Fen-us%252Foffice%252Fround-a-number-to-the-decimal-places-i-want-49b936f9-6904-425d-aa98-02ffb7f9a17b%253Fui%253Den-us%2526rs%253Den-us%2526ad%253Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId--1246733839%22%20id%3D%22toc-hId--1246733838%22%20id%3D%22toc-hId--1246733838%22%3ERound%20a%20number%20to%20the%20decimal%20places%20I%20want%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fround-a-number-to-the-decimal-places-i-want-49b936f9-6904-425d-aa98-02ffb7f9a17b%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fround-a-number-to-the-decimal-places-i-want-49b936f9-6904-425d-aa98-02ffb7f9a17b%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1795279%22%20slang%3D%22en-US%22%3EBetreff%3A%20Rounding%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795279%22%20slang%3D%22en-US%22%3E%3CP%3EDear%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20answer.%20I%20know%20the%20function%20you%20mentioned.%20But%20rounding%20only%20changes%20the%20way%20the%20number%20is%20displayed.%20The%20actual%20number%20behind%20it%20can%20be%20different%2C%20e.g.%3A%201.2345%20can%20be%20rounded%20to%201.23.%20But%20it%20is%20necessary%20to%20use%20ROUND%20function%20for%20each%20calculated%20value%20denoted%20in%20currency%20(e.g.%20USD).%3C%2FP%3E%3CP%3EOtherwise%20Excel%20will%20make%20further%20calculation%20on%20the%20basis%20of%201.2345%20and%20not%201.23.%20I%20am%20wondering%20if%20it's%20possible%20to%20automatically%20round%20the%20value%20so%20that%20in%20the%20next%20operation%20the%20rounded%20value%20(1.23)%20is%20used.%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3ETomasz%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
 

Hello. The question is how to force Excel to make calculations on numbers rounded to 2 positions after decimal point, how it is used in accounting. I mean to treat e.g. 1.2345 as 1.23 in further calculations.
I can use round function each time but is it possible to make Excel do it automatically?
I'd be obliged for help.

5 Replies
Highlighted

@Tomasz_Scianowski 

 

=ROUND(A1;2)

Round a number to the decimal places I want

https://support.microsoft.com/en-us/worldwide?returnURL=https%3A%2F%2Fsupport.microsoft.com%2Fen-us%...

 

Round a number to the decimal places I want

https://support.microsoft.com/en-us/office/round-a-number-to-the-decimal-places-i-want-49b936f9-6904...

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Highlighted

Dear @Nikolino ,

Thank you for your answer. I know the function you mentioned. But rounding only changes the way the number is displayed. The actual number behind it can be different, e.g.: 1.2345 can be rounded to 1.23. But it is necessary to use ROUND function for each calculated value denoted in currency (e.g. USD).

Otherwise Excel will make further calculation on the basis of 1.2345 and not 1.23. I am wondering if it's possible to automatically round the value so that in the next operation the rounded value (1.23) is used.

Best regards

Tomasz 

Highlighted
Best Response confirmed by Tomasz_Scianowski (Occasional Contributor)
Solution
The "Round" command limits the number of decimal places used for the calculation.

The function with which this can be corrected across the board for the respective table can be found in the Excel options.
Under -Advanced- at the bottom of the point -When calculating this workbook- set the checkmark for -accuracy as shown-
The only special feature: the other decimal places cannot be restored in the table.

Thx for your Time and Patience
Nikolino
Highlighted

@Nikolino Thank you very much. That is what I was looking for.

Highlighted
Your Welcome

I'm glad could help you

I wish you a nice day / night with health, joy and love.

Nikolino
I know I don't know anything (Socrates)