3. Why is my rounding bugging?

Why is my rounding bugging?

Sure let me call my hacker friend to get into your computer and know what you mean instead of you giving is the details!

That is me being a jerk but honestly you aren't putting effort to help, you said "decrease decimal function", there are literally over a dozen rounding functions, not even counting other features, here is a some https://exceluser.com/1837/overview-of-excels-rounding-functions/

I'm going to assume you mean the two icons on the home tab, this is just a way to show less of the number BUT it is still there, the reason it is inconsistent would be due to floating points in computers, here is a link about it if interested: https://en.m.wikipedia.org/wiki/Floating-point_arithmetic

But honestly, i think it is VERY unlikely that it would happen to you with 2.45 but I could be wrong.

You can increase precision on option IIRC, but to avoid this, i suggest to just use proper functions like rounddown().

/r/excel Thread
Previous
Next

Recently removed from /r/excel

Excel Solver either keeps changing the answer or gives the same wrong answer. How do you get rid of the blasted format painter icon that obscures text - Excel/Mac 16.72 - Microsoft 365 What’s the easiest way to share an excel document with Reddit? How do I set a character max and format? Calculate total number of years months and days from already calculated set of individual results displayed as years months and days. Dynamic Scheduling Based on Rotation and Start Day Is there a way to turn my date range in text form to a two-column number form date range? Is there any way to freeze the top row by default or otherwise save the state of frozen cells? Vlookup issue with value that exists completing the excel exposure Complicated MOD function that possibly might just be algebra.. Comparing two workbooks for differences Microsoft Money for Excel released today How do I insert a number of blank rows between every row of data, and then copy each row down? Copy data into new sheet with a break after every nth row or copy formula into every cell with breaks every nth row

More Random Comments

White House Bewildered Over Manchin Walking Away From Agenda [Serious] What event in your life still fucks with you to this day? Pride month ships poll There can only be no loneliness when there is no person 26 [f4f] Canada, BC /PNW/Anywhere Am i entitled to paid breaks? Shroud on Diablo Immoral's Addictive P2W. History of turn-based battle systems RPGs? Do you guys agree that your first year of university/first year out of high school is your final year as a teen? I’m gender confused and wondering if this is where I can ask questions u/NoSoundNoFury explains what it's like to be an incel in a downward spiral and how he broke the cycle Is/was Ari a cutter? Check the arm scars [Serious] What event in your life still fucks with you to this day? What are your thoughts on the cost of iRacing? Est-ce que vous jugez les courses des gens au supermarché?