I’m trying to derive the year in which a threshold is reached (sorry for the incorrectly formatted years). I.e when $10B is achieved, or $12B. The model has a lot of moving components so the thresholds move around based on about 15-20 different assumptions. What would the formula be to help get this? Basically once I know the year, I have to layer in an incentive component but the years will change based on the drivers.

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

Minifs(years, total, “>=“&threshold)

likehelpful

This seems to have worked, I think! Thanks.

like

Thanks for the help everyone! Was killing myself with complicated formulas and sometimes simplicity is best…

like

Sorry to clarify, it needs to be multiple thresholds, not one.

So what year at $10B, 11B, 12B, 14B and 15B, etc. so it can’t just be once it hits over a value and that’s that because it’s easy

You would just put the thresholds somewhere and anchor the references in formula and drag across thresholds so that each one is running the same formula with a different threshold referenced

XLOOKUP(Threshold Value, 67:67, 69:69, , -1) should do the trick

Ah my fault, flip the -1 to positive 1

like

Related Posts

What’s a fair expectation for my first raise? Publicly traded co with ~2500 employees. I’ve been doing litigation with the company for almost 3 yrs and have only had a 2% cost of living raise so far. Graduated in 2014. Base comp is $127.5k in the Philly area. I see salaries all over the place in this site and it’s hard to tell whether mine is competitive.

like

How much are dental office managers making these days in NYC?

like

Hi fishes,

Please help me choose the right option considering yearly hikes, promotions and good projects.

Tech stack - SAP finance
Yoe - 8.5 years

Pwc offer - 19 fixed + variable + 1.5 lakh joining bonus
Accenture offer - 22 fixed + 0-27% variable + 1.5 lakh joining bonus

like
like

Hi Fishes, If I join Bank of America (BA Continuum) on October 1st, will I be eligible for hike in coming appraisal. Bank of America BA Continuum India Pvt. Ltd.

like

Hello All,

I have got an offer from one company with a 32L + 15% variable. Now I got two other offers with 36L. Should I go for it?

like

Hello...

Can anyone tell me what is the salary structure like allowance , facility , or other things in American express apart from CTC offered.@

like

4.75 YOE in consulting. What comp should I be aiming for? Looking at strategy and business development roles across industries. I’m at 110K right now.

like

Where does Accenture Interactive's salary band start with 2 YOE?

Are salaries negotiable at performance review and/or promotion?

like

I have 2.5 years of experience as a BI consultant primarily working with SQL and Power BI. I feel a little underpaid while currently making $75k. All of my performance reviews have been positive and I have been the lead/only BI developer on two of our largest and most public projects this year. Any thoughts on what I could ask for at end of year reviews for a salary increase?

like

Anyone know Deloitte core business group in Deloitte consulting LLP?

Salary range, business outlook of this group amid layoffs and green card initiation timeline?

Post Photo

Can anyone tell me about the increment cycle for Internal Communication professionals at Amdocs? How much increment do they offer? I'm aware it's subject to performance but I'm still curious. Would appreciate some light on this.

like

When will the hike letter be released ?
Will the hike be reflected in Nov salary or in dec salary ?
I would like to know avg expected hike for career level 11

Does PWC India consider counter offer or drop the candidature if they cannot match the CTC?

like

Has anyone who lateraled for an experienced IB role gotten moving expenses reimbursed? If so, how much was it? Thanks

like

Hi - I've have 8+ years of experience. Cleared 2 technical rounds in Barclays, waiting for manager round which is next week. Have counter offers for almost 30. How much can I expect in barclays? How is work life balance ? Do they give permanent WFH? How is growth and hike every year? Please help. Barclays

like

I’m a Dental Hygiene student in North Mississippi. I have worked as an dental assistant for 11 years. Hygienist in my office wrk on commission. What is the pay difference in a commission hygiene and one paid hourly.

like

Hi Fishes,

What should be the CTC for Senior Product Analyst Role in Global Risk and Compliance (GRC).

Having Total 9+ Yoe

like
like

More Posts

Thoughts on specialty life insurance? I don’t have my LLQP. This is based in canada. They are offering paid training

like

Anyone ever heard of Exabeam ? Thoughts on company , culture, work? Principal security consultant. Thanks!!

like

Anyone else get this? Feels like a scan, email domain doesn't seem legit.

Post Photo

Hi everyone! I have 7 years of experience in social media marketing and looking for a change. Please let me know if there is any opportunity in your organisation that I can apply to. Location: Gurgaon

like

Are your clients still all excited about Snapchat even though the cost is quite high and the metrics are only marginally better than last year??

like

Did a bunch of agencies just go on a firing spree before Christmas?

like
like

Is anyone working somewhere with a hiring freeze right now? I started this job about 6 months ago and I'm worried I'll be the first one out now that they're officially pausing. Should I be looking for another job, and how much will this affect my resume if I get laid off?

like

I am currently a civil engineer thinking of switching to software engineering. I got my masters in water resource engineering where I was coding a decent amount for assignments and it has really stuck with me. Unfortunately, in my current role and field (civil), I don’t really get to do much coding. Does anyone have a similar experience of jumping ship to do software engineering? What would be the best way to go about it (coding bootcamp, another degree, something else)?

like

I just get paid in production company lunches

like

Hi Fishes,

I am going to start as a Big data Developer. I have an experience of 3 years in non-IT MNCs and current CTC is 5 lpa for me. What is the salary I should expect as my earlier experience is not relevant to the field. Please help.

like

Assurance Professional of the Future Program for Senior 1s = Milestone event??

like

Laid off back in Feb, Since then, decided that I won't be held ransom by the marketplace so i decided to start a consulting business. Sometimes challenges are opportunity #hanginthere

like

I have an AWS loop for a SFA any tips past LPs and STAR? Should I be prepared for a case study or excel test ?

like

Hi all, I’m new to the freelance game so this may be a dumb question but how far in advance do you look for your next gig? My contract is up in December so I’m trying to game plan the best time to start really engaging.

like

👀 We’ve all heard of *DWB, *WWB, *SWB & more.

💡 If you’re consulting while Black, you’re probably aware that situations can arise for us which require careful handling.

💭 It’s helpful to ask questions & get support/answers in a judgement ➕ snark-free environment. So, I invite you to join the Black Consultants Strategies & Tactics bowl

🔍 Use the Fishbowl search function to search “Black Consultants Strategies & Tactics” and request to join today!

*driving, walking, & shopping while black

Post Photo
like

I am on a credential program in California ... Intern eligible waiting on student teaching however, i am looking to relocate to Texas. Would i be able to apply for internship in the state of Texas?

like

Cogno AI Hey fishes, One of my friends, got offer in cognizant. She have an epfo account with inactive UAN and she changed her name in aadhar recently and this epfo account has the past name. So she raised request for name change 2 months ago and still it's processing. And now cognizant asking the acknowledgement of changed name which the previous company cannot provide for obvious reasons. Will it affect the doj? Or anyone had this kind of problem before? Cognizant Cognizant Technology

like

Currently maxing out my 401k and HSA and investing about 1k/mo in ETFs. Also recently started buying I-bonds given inflation. What are other things I should be thinking about?

like

Does Uniqlo have the best budget plain t’s?

like

Additional Posts in Excel Genius

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

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

like

Anyone know what these badges are?

Post Photo
likefunny

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!

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

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

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

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

likehelpful

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

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

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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