•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Small Business rounding issue
Our take
Hello, fellow spreadsheet users. I’m seeking assistance with a rounding issue in my sheet. Despite using the same formulas for a year, my total is calculating to $6133.33 instead of the expected $6133.20. This discrepancy arises from multiplying 153.33 total hours by $40 per hour. The formulas appear correct, but something seems off, and I’m unsure how to resolve it. If anyone has insights or solutions to this rounding problem, I would greatly appreciate your help. Thank you!
Hi,
Can anyone identify why my spreadsheet is calculating the total to be $6133.33 instead of $6133.20?
153.33 total hours x $40/hr.
I've been using the same spreadsheet for a year, the formulas are correct, this hasn't happened before, I can't figure out how to fix it. This is on sheets.
Thank you
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Blank cells are being summed as a value greater than five using a SUM(IF functionHi! I have a large dataset of 7-day schedules that I am summing to calculate breaks. The function is setup like this: =SUM(IF(CELL1>5, 0.5, 0)), (IF(CELL2>5, 0.5, 0)) and so on until all seven days are tabulated. Because a full time person would only work 5 days a week, at least 2 days are blank per row, but we're open all 7 days and I want to sum the entire spreadsheet, so I have to count all 7 days. A full time person should have 2.5 hours per week. For some reason the function is mostly working, but about a third of the results are larger than they should be because it's counting some blank cells as greater than 5. For example, a part time person working only 3 days should have 1.5 break hours, but the function returns 3.5 because it is counting all the blank cells as containing a value > 5. What's really strange is it is only doing this some of the time. Every row has at least two blank cells, but only about a third of the sums are wrong. I can't figure out why. The columns are all formatted as a number. The value does update correctly if I manually enter a "0" in the blank cells, but this is a very large dataset and that would take forever. Thoughts? submitted by /u/andylefunk [link] [comments]
- Slow spreadsheet - need troubleshootingHi, I have a spreadsheet that has two tabs, one is essentially the original data which is YTD driven for a particular GL account, the company has smaller amounts of transactions, so by December we are talking about maybe 3-5k rows of transactions for the account total. The main tab being utilized, has about 30 columns of look up and sumifs formulas referencing the source data and in total approx maybe 500 rows by year end? To me it doesn’t seem excessive. I’ve dealt with way heavier spreadsheets that have more omph and run faster. But for some reason this one is slow as all hell to work in. I’ve even tried barcoded some data and not seen any improvement. I’m not too techy into what else could be slowing it down. And ideas on what to troubleshoot from here? submitted by /u/SlideTemporary1526 [link] [comments]
- Time In Lieu SpreadsheetHey All, I have used Google Sheets forever but my new job uses Office and I am struggling with some of Excel's functions. I'm trying to create a spreadsheet that tracks my time off in lieu (TOIL) so I know where I'm at. I've created the bare bones of the spreadsheet ash shown in the image but I need help cleaning it up. Ideally I would like to have all of the time columns (B:H) only have hh:mm format and then all of the 0:00:00 values that haven't been used not to be shown. In cell L1 I would like it to show the most current level of TOIL, again in hh:mm format. Is this possible or am I asking too much of Excel? Thanks in advance. https://preview.redd.it/c8u5ha2cxszg1.png?width=1001&format=png&auto=webp&s=3985daa3d11541abed488f377c62e375f6ab1224 submitted by /u/Silky_45 [link] [comments]
- Formula works in most of the cells ant not othersI downloaded a budget excel that was basicly what i was looking for. I coped it 13 times in the work sheet one for each month and 1 for a yearly total. The yearly one is running a current total for the year for what was done so far. My issue is that most of the cells this will work in but there is one section it will not do a running total for unless i have an amount in every cell for the 12 months. Any ideas what could be the issue submitted by /u/cbeard0245 [link] [comments]
Tagged with
#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#Excel alternatives for data analysis#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#google sheets#Excel alternatives#business intelligence tools#spreadsheet