Hi! I need to give indexes and I compare -322 with 5. The formula I use is iferror(-322/5*100) but the index I get is -6399. This is the only account with that strange difference. Is there something I am not seeing? Because I approach all of them in the same way.

How much are your biweekly paychecks after taxes, insurance, 401k contributions, etc. and how much of each paycheck do you tuck into savings?

Amazon stock is down to below 3000. Bought at 3300! Thoughts? I’m sure it will go back up, but when? And by how much? Appreciate any expert guidance!

I am new to DI...can someone please tell me is it mandatory to claim telephone and LTA...can't we change it to taxable component ? Because I need more In hand

How do you calculate IRR for a write off? Is it just 0% or should it go negative? There’s no cash moving after the initial investment so not sure what to do.

I'm in my second year of TFA, and am thinking of sticking with this teaching thing (crazy, I know). I'm wondering if you have savings accounts I can use to work towards a down payment.

Do any real estate lawyers out there know of/can direct me to a ROFO agreement to purchase commercial property? I’m working on one now (but using a ROFO to purchase equity interests as a basis) and would like to see what other people are doing. Finding a good one has been hard, as this kind of thing isn’t always required to be filed with the sec and every search I’ve done basically pulls up garbage. Also, are there any provisions you’d consider absolutely crucial from the owner’s side?

Anyone got a loan with Guaranteed Rate? Started looking for a condo(Chicago) and keep seeing them pop up. Looks like they charge $1290 lender fee, but wanted to see if anyone had experience with them

How do you all split your 401k contributions between pre-tax and tax deferred (pre-pay tax) contributions?

Can you set automatic investments in TD Ameritrade? Looking to DCA at the start of every month into index funds without having to manually buy. Thanks!

Is this portfolio allocation pretty standard for index funds? What am I missing or not considering?

VUG Large Cap Growth - 20%
VOT Mid Cap Growth - 15%
VBK Small Cap Growth - 15%
VTI Total US - 25%
VXUS Total International - 25%

Do anyone of you subscribe to the motley fool or any other stock advisor tools? Recommendations and thoughts on how useful they are?

I'm working on a Fintech startup related to commercial banking pricing. We would like to do some "expert interviews" with current RMs (we would compensate your time.) We want to better understand the friction points when it comes to price C&I or CRE loans. Please DM me if you are interested.

We are not looking for any private information, but more anecdotal evidence of issues that can be improved.

Looking to buy 35K marriott bonvoy points. Let me know if anyone’s willing to sell?

How much do you keep in the bank vs brokerage?

Newbie here. Did any one engage a financial planning service? I’m 34 with young kids, no debt, and $300k in cash. Absolutely no other financial/estate planning and overwhelmed!

I donated once to a candidate and now I get 3 messages a day asking for money. I feel like I'm in a relationship and I'm a sugar daddy or something.

Just want to know how much people actually pay for mortgages on a salary about $120k I am looking at homes and I want to upgrade but I don’t want to be house rich. I don’t mind living below my means but I also want my children in a better school district. Just confused…

If I have a six year old and 150k in a 529, can I say I’m done?

Being a jr. banker is like being a racing horse. A litttle man stands on you and whips you on ass while you carry him. He gets tons of money and you hope to get laid because of job title.

Is it difficult to move without a reference. I got all the skills needed in current job market. But looks like getting a job call itself is difficult.
Or is it because of My H1B visa status.

What would be the hike percentage for a new joinee who has been in Fidelity for 6 months? Grade : 4

What salary can I expect for this role in Kyndyl? I just need a base for negotiation. I have three years of experience in IBM/Kyndryl and the role is System administrator.

Hi Everyone,

I having below offers in hand. Please guide me for a wise decision in selecting a company

L&T - 10.5 LPA
INTELLECT DESIGN ARENA - 8 LPA
EMPOWER RETIREMENT- 10 LPA
FUJITSU- 11.5 LPA
TEKIZMA - 7 LPA

CTC is not a matter. I need good learning, WLB and good culture.

Hi all! I work in digital marketing / organic social. For those in organic social what platform do you use for scheduling posts, analytics, UGC, managing influencers etc? We currently use bizzare voice/curalate. I work for a national retail brand so we are posting 2x a day with tons of UGC and in house content. Your thoughts and opinion are appreciated with all platforms! :)

Hi! I started at a new company 2 months ago and while I’m really enjoying my job so far, I’m having a hard time gauging whether or not I’m doing a “good job.” My role seems to be always evolving, which is fine and I actually enjoy being a support to the greater marketing team, but I feel like I need better defined targets to make sure I’m meeting expectations. Also, when I ask my boss what they’d like to see, I don’t ever get a clear answer. (Cont’d in comments)

How does a regional firm auditor interested in Deloitte’s forensics practice get their foot in the door?

Any update on work from office in TCS? Are they still calling ? As no. of cases are increasing

I’m switching over to consulting in June and I’m already assigned to a new project for the firm. I have a meeting with the Engagement manager on Wednesday and I was wondering what questions you typically ask or important information you need to know before joining a project.

Do titles in industry matter when exploring an exit? Which title seems better - Principal - Strategy or Senior Director - Strategy if everything else is equal.

How many rounds of interviews for a consulting role at Deloitte? I am interviewing for a Agile Lead Role at Deloitte (I believe I would be at the consultant level). I have completed the technical interview last week and just got a behavioral interview offer for tomorrow. Will there be another interview after this?

How will be work life balance for Software Engineer in consumer and community banking
Profile for Salesforce Developers in jpmc?

Anyone at ZS willing to chat about a SIPA role? A recruiter reached out to me.

What are some of the top B2B marketing agencies in the west coast? Any perspective what makes them great?

Looking to get a dress watch compatible leather strap in 21mm with deployment clasp- any recommendations?

Any book recommendations on excel modeling for real world business applications?

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

Would anyone be willing to teach me vlookup?

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

What's a simple way to explain data organization to people who don't use formulas very often? People on my team love creating many tabs instead of adding columns for recording the same type of data...

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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?

Top 3 most useful VBA macro codes you use everyday? Would you mind sharing the VBA code or a link showing the code? I’ll start (cont.)

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

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?

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?

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Today I encountered the strangest bug I have ever seen with Excel+Thinkcell. I have, as always, a separate Thinkcell sheet where I gather and structure the data (from other sheets) I want to make charts of. However, when linking this data to charts, all formulas in the sheet turns into values. This has never happened before. Anyone else seen this and knows what is going on?

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

Question for those of us that dabble across data science and not just excel. I want to get some good training on SQL. Anybody know the best certification program that has the best cache in the market?

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)