Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

Related Posts

got a CIS form filling link from cognizant, what it is.. i am experirenced java developer...interview clreared at cts and also had salary discussion

like

Hi…I am an Ex employee of Accenture..I need Employment verification letter for RFE For H1B visa.. Accenture has provided the letter, But in the letter the purpose Was written as “ for procuring Lawful Permanent Residency “…. Now I am not sure if I can use this letter as Employement verification letter

like

For those of you without a home office: Where do you usually work? My desk is in my bedroom and I’m considering sacrificing aesthetic to move my set up elsewhere

like

Pwc advisory is hiring
Dm me for referrals
Fresh graduates have opportunities too

like

What is the salary range in Accenture for Level 7 in the Applied Intelligence Team? Job location - Bangalore

like
like

Any downsides to leaving a “Counsel” role and moving into a “Legal Affairs” role? Still practicing and representing the company, just a difference of titles, so core work remains the same - what do you think?

like

What’s the scoop at BDO’s national training in Dallas? Anyone have anything juicy they’d like to share?

like

Stranger Things 2. OH MAN! It's SOOOOOO GOOD!

like

Hey,

I'm currently working for Siemens and I'm planning to join
Uplers as a freelancer. Is that a good choice ?
I hear that they pay well. And since I'm in banglore it'll be good for me to get one more source of income.

like

anything going on today? hearing what feels like more than normal amount of sirens going by (in east village for reference)

like

Where can I play some pick-up soccer/join an intramural league in the city?

like

Anyone recruiting for Zogsports?

Interested in joining a team in Manhattan for softball, basketball, dodgeball or kickball.

Decently athletic and would love to meet new folks :)

like

Planning on a trip from NYC to Miami. Need 2 suggestions — 1) best neighborhood to stay for 2 laid back women in their late 30’s, 2) best way to move around between car rentals vs Uber? If car rental, any recommendations on which rental to use given the astronomical gas and rental prices?

like

Sorry Idk which bowl to share but my Asian friends, can we get more visibility on this

Post Photo
like

Happy to review and refer for Deloitte UK

like
like

How is PWC SDC external audit practice? I am Chartered Accountant with 2.5 YOE. Currently working with EY GDS as Senior and have offer letter from PWC SDC of 17.75 and offering Senior Associate 2. Any folks here from PWC SDC who can help me to decide please.

Hi Guys,

I have an offer from JPMC of 27 lacs Fixed and HR round pending for Morgan Stanely Bangalore.
How much should I ask?
YOE:7 Yrs, Stack: Scala Spark

Also which is better JP or MS? I heard rumours about Job security issues at MS. TIA

like

Best Coffee in SF?

Additional Posts in Excel Genius

How long did it take you to become good at excel? Like fast?

like

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

How do I compare two sheets to make sure they are identical?

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Would anyone be willing to teach me vlookup?

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