Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like
Posting as :
works at
You are currently posting as works at

If it’s your data table for presentation. I always doing to the rounding on a separate table that doesn’t need to look pretty, then just simple lookups.

It is a bit annoying, but it fixes this issue

like

Or just cover your arse and have a footnote explaining that due to rounding, totals may not match exactly the sum of numbers on screen.

like

Not sure I understand what you are looking for.

The proper way to round numbers in Excel is by using ROUND(reference, number of digits), but of course rounding the sum of the numbers will not give the same result as summing the rounded numbers. That’s usually ok in most professional settings, although a footnote is good practice.

like

A footnote is best as others have said.

I find that even when dealing with investors, lenders, and other 3rd parties, noone gives a damn if things don't downadd. Which is great, because it's a real pain!

My typical footnote says something like "figures and calculations may not downadd as they are based on underlying data"

No I just made it up

Related Posts

What are the interview questions asked for a lead business analyst at legato healthcare?

Is the company good enough?

Anybody from legato?

like

Honest question: I’m training for my first marathon. Does it really matter where I get my calories from? I am burning between 1,000-2,000 calories a day training and my body seems to be hanging in there ok. Does it truly matter if I’m eating ribeye vs lean chicken? I feel like getting to 3,000-4,000 calories a day in a healthy fashion is really really hard. Just from a volume standpoint.

like

Anyone at Connections in Chicago next week?

like

Offer from industry has 3 weeks PTO and 5 sick days. All federal holidays plus the day after thanksgiving. Seems space to me. Am i wrong?

Accenture Hiring for Coimbatore location, interested folks share resume at ish89jn@gmail.com for referral | Refer skill demands in Accenture ATCI Coimbatore Location | Exp:2 to 14 yrs

Post Photo
like

Cisco

Pros:

- fairly decent place to work (from someone who worked with the Vancouver and San Jose offices). never met a blue badger (permanent employee) who had awful things to say.

- Ashley Goodall (their SVP, Methods & Intelligence) co-authored a brilliant book on leadership and people management called “Nine Lies About Work” that makes me believe they can be an awesome place to work

Cons:

- red badgers had low morale since they’re contract workers and can be terminated at any time

Has anyone noticed a decline in their eyesight since starting work? Second year associate noticing my eyes are struggling (I have had contacts/glasses my whole life) much worse than they usually are nine months post-eye exam. Any tips for decreasing the damage?

like

Anyone have any experience in evaluating an offer that comes at a pretty steep pay cut (20%) but you get a chance to do something super interesting?

like

Anyone works in Kearney T&T practice? What kind of clients do you work with? (PE/Corporate, location?) and what kind of projects are there? Any insight is appreciated!

like

Do any of the tax software programs actually handle complex K-1s well? I probably need to just get an accountant but… I like knowing the ins and outs myself and don’t feel like shelling out that much…

like

Need 11 likes for dm.pls help

likeuplifting

How many times do you consider it ok to show the same house to the SAME prospect until he decides to buy it or not?
It's been 4 times so far.

like

Is LDC is a good company?

like

Have you ever changed your mind after signing an offer? If so, how did you go about it?

like

Anyone else always regret going to happy hour with coworkers? I always feel like I may say something that’ll get twisted and used against me some way. Then I think about it for days 😞

likefunny

I am only using men dress Brooks Brother now as they fit me well, non iron and within the budget Would like to try something else. Any other alternative?

Hi,
My documentation process was done about a month ago with an
IBM . Today HR called and asked about when can I join? Does this mean they are releasing the offer?

like

What is the band heirarchy in hcl? I have got band 2. What is the exp range fr it?

like

Hi floks,

I have around 7 years of experience of which -
Yoe - 4 yrs in FDD practice and 3 years in audit practice in big 4s. By qualification, I am CA and CPA.
I am looking to explore job opportunity in United States and want to understand the opportunities and how likely it is that I will get visa sponsorship from my current or any potential employer.

Any inputs or suggestions, will be appreciated. Thanks.

like

Did anyone got into Natwest as a fresher offcampus? (As a software engineer)

like

Additional Posts in Excel Genius

Please help: 2 line items of data is getting dropped from the source to the pivot table. The source is an excel sheet in the same workbook so I can quickly verify that the data is there. Now I’m getting REF results from my GETPIVOTDATA formulas. How do I begin to troubleshoot this?

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Does anyone know how to keep in leading zeros when converting to a number, so I can do a vlookup across data sets?

like

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?

like

Boss seems to think I should learn Access and wants me to find a class. I can fumble around in VBA, but really only through using google. Is Access worth it or is there something better?

like

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

like

need to do a timeline with lots of information over a long period of time. I wanted to that in Tableau, but partner will not pay license and data is sensitive so I cannot use Tableau public.
Do you have suggestions?
The requirements are the following:
- No online input data upload (so local editing)
- The produced output file must be local and easily exportable and readable
-timeline must be interactive (filter/click/zoom in/out/view detals etc.)
- free

Any kind of help is really appreciated

like

Not Excel related, but any folks in strategy willing to suggest the best and most useful data platform to learn? I’m thinking along the lines of Tableau, Power BI, etc.

likehelpful

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

I’ve heard of power query/pivot multiple times but what are their advantages compared to traditional excel? Anyone can share some examples?

like

Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.

Post Photo
like

Coolest, best, or nerdiest thing you've been able to do with Excel?

like

What scenarios would you use offset vs. and index/match formula? Also, what does including >1 [width] do to the offset formula?

Im trying to grasp why if I isolate the offset formula (currently being used within a sum product), I’m getting a spill error.

like

Hey Geniuses,

I’m looking to teach myself how to build financial models and LBOs for some PE interviews. Do you know of any free or reasonably priced resources I could use?

like

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

like

Just wanna say thank you to this group of beautiful people, always willing to help each other reach a solution!

likeuplifting

Really wish my clients didn’t use Google Sheets. This sucks.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal