I use both excel and google sheets, and love them both for different reasons, but they don't agree on which direction decimal rounding goes and it makes me crazy

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

Stop using Google Sheets...problem solved

likefunny

This drives me nuts too!!! Thought it was just me.

like

Excel is confusing here. Moving the arrow left implies to make that you’re making the number shorter. Fall for it every time...

like

It's almost like they're saying it's the decimal point itself that's moving left, revealing more of the fractional part. But I don't like it

Lol excel itself I could not remember which direction is which anyway. Always press both buttons to get what I need, always

funny

Same

this, and a million other things about google sheets.. i was delighted to see earlier this week they finally added Remove Duplicates 🙄

Related Posts

What would be the best career path for someone who likes to be creative in the tech world? I have dabbled in marketing, not a huge fan, currently in client success and can confidently say I would like to try something else…just not sure where to go next…

like

I am working in Softtek from 2.8 yrs , now I want to switch but even now my background Qualification of being Mechanical Engineer gets in the way for most companies as that's the basic criteria as BE in IT, computer science or related feild and CV gets rejected in screening all the time .

like

Any openings for Data Scientist in Jio?

Interactive Brokers vs Tekion

Hi Everyone,

I got an offer from Interactive Brokers and Tekion for the role of Software Engineer.

Compensation offered is nearly same.

Current experience -2 yrs

Which one do you think is better?

like

Looking for a master class or progam on power query. Suggestions?

like

I found this person’s resume on their LinkedIn…they took a generic Google resume, and photoshopped their experience on top.

Post Photo
funnylikesmart

Does S&P Global revise an offer based on the counter offer ?

like

Manager: why isn’t planning done
Me: we literally scheduled my time to do this next week.
Manager: can we have this done this week
Me: with what time 🙄

likefunny

How do you stop putting yourself down? I don’t mean to do it and it just comes out of my mouth and then I feel SO awk after.

like

Looking for pain management doctor recommendations near northeast Dallas

like

Hello all, anyone interested in starting a tech training business or side business. We are very well established in B2C and recently started to offer platform as service where a tech mentor or training providers can use our LMS, courses and hands-on IT labs to open a full online business.
This is next level from Udemy or teachable.

Who is for?
Tech educators with passion to teach but also want to turn skills into business.
You must have ability to bring students for your business

like

Anyone have any experience in coping with someone’s Narcissistic Personality Disorder? It’s my mother, and this has psychologically devastated me all my life, but I don’t know whether to keep trying or cut her out.

like

HELP!! I left the firm last week and totally forgot to make a payment on my Amex card($1,000) Just login to Amx account and the account is cancelled. I just made a payment to pay off the balance. Cont

like

Hi there!

I’m trying to get my grandmother (81yrs old) travel medical insurance for a trip to the US, where I live. She’s in good health and lives in South Africa. I can only find travel insurance options for those who are aged 80 or below.

Does anyone know of any companies that offer senior travel/medical insurance (81+) or have any other recommendations? Or does she just come without travel insurance?

Any advice would be much appreciated. Thank you in advance!

like

I have 2 offers currently.
Mercer - Investment Strategy and research (Sr. Specialist)
Aranca - Investment research and analytics (Assistant Manager?

I want to move closer to due diligence process or core research. Which one is better profile?

like

Anyone can provide referral for LTI, Nagarro, Mindtree, capgemini

like

Anybody Joinng in June at pune location?

Anyone looking for a one bedroom apartment just north of the city in Westchester county ?

like

I fee this in my soul. It's the old saying I guess. Gotta work twice as hard to get half as much!

like

Is PwC laying off H1b holders?

like

Additional Posts in Excel Genius

I’m looking to get a second laptop strictly for the use of excel & financial modelling. I currently have a Mac and would prefer to spend around $500 CAD. Any suggestions?

like

There are a lot of recommendations for Excel plug-ins for Excel but they are almost all for the Windows version, so what recommendations for plugins are there for the Mac version?

like

Having an Index Match problem!

I would like to multiply the values in column C, "Company X Volume" by their corresponding Price in Column F. To do this, I know I have to index match, but I'm not sure how to do that correctly given these are not exact matches.

Any ideas?

Post Photo
like

I am running a macro that uses "Application.FileDialog(MsoFileDialogType.msoFileDialogFilePicker)" to select a single workbook file and then open the selected workbook.

Cell A1 on Sheet1 of the workbook that is running the macro contains sheet names that can be selected from a drop-down list. I want to be able to use the sheet name that is in cell A1 to select that sheet in the newly opened workbook.

It's probably something simple, but I can't seem to get it to work. Any ideas?

like

I have zip-zip routes for a trucking company. Most of them have price info but some are blank. Is it possible to do a count of those with price and without price in two columns of a pivot? I want to show that prices are missing across the board and that we can use the majority to replicate the missing few.

like

My data tables are consistently not calculating all the values which I have encircled. The values are not increasing with the multiple. Could someone help advise

Post Photo
like

How do you make defined name ranges stay the same when the source is changed in power query? I’ve been really struggling.


I have a model with many defined name ranges in it that are referenced throughout. Each named range is set to be 250 rows long that way it works as long as the data set has less than 250 responses. However, when I switch the data source in PQ, it inexplicably shortens all my named ranges by around 4-6 rows (for example, one that was $B$3:$B$252 becomes $B$3:$B$246). Help?

like

Anyone have any resources for improving your skills building valuation models for the purpose of CDDs in excel? I’m moving to a new firm and my old one often had our offshore team build out the majority of our valuation models. Now I’m going to be responsible and I want to prep before I onboard.

like

Can you use the SUBTOTAL feature with formulas as well? Such as IF statements

like

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA

like

Been in consulting for over a year and wondering what other formulas other than index/match and vmatch is useful.

If I have NAME, REF etc errors in different spots of a very large worksheet, is there a quick way to delete all formulas that are bringing errors?

like

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

like

What's the F4 analogy in Office 365?

like

Thoughts on learning VBA? Is it useful in consulting? Many people argue Python is better to learn overall?

like

I have a filtered date data and wanted to only copy the visible cell in column A and paste it to the next column (column B) with special paste. Because it is filtered data, I could not simple copy the whole column and paste it all at once. What is the quickest way to do this? I tried to search macro online but still cannot do it right.

like

Can someone help me with recoding surgery question into binary variables? I’d so appreciate your help! TIA

like

Can somebody help me with the IF formula here please? I want to match Column K and Column O with No as the select values. I’ve tried =IF(K6=O6=“No”, ”match”) but it didn’t work. Thanks in advance for your help!

Is there a way to wrap your header text within access database?

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

Scan your QR code to download
Fishbowl app on your mobile

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