can anyone explain how offset formula works in scenario analysis where the formula is =OFFSET(reference,,scenario). Like how does excel know which number to pull?

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

The scenario toggle tells excel how many rows or columns to move over. The reference cell is where excel starts.

but the formula I posted didn’t really specify row or column number, just scenario number. How does excel know to pull say revenue number or net income number?

Related Posts

Director level bonus %? Is it 1.5x?

likehelpful

Big legends Guide to Three-Fund Portfolio. Yay or nay? Additionally, please share personal finance books that you recommend to newbies! Thank you and happy holidays!!✨

like

Any favorite spots for Viet-Cajun? Staying downtown for a few days and I’ve always wanted to try. Work is covering it, so pretty flexible budget wise

like

Hi All, I've been offered a 10.7LPA by TCS. What will be my take home monthly and the take home on a variable payout month? Approx value is good.

TIA

Have any one used a resume coach or service for in house job search, particularly for IP and product counsel positions? If so, how did you find a good one? Thanks!

like

Can you cut 18mg Delmosart (i.e. Concerta) to get 2x 9mg?

like

My first time buying a home and my fiancé second. Last time he was able to sit down with the loan officer and review any questions he had about the documents because there is a lot of language in there that isn't used by average people. Our current loan officer from the same bank branch wants to do everything electronically, and it's a battle just to get our answers. We're willing to lose the loan before signing on to a debt of $350 without knowing all of what we're signing on to.

like

Anyone working as a nurse educator for HCA? Interested in what the salary mark is.

like

How does someone transition from low-end ID (MVAs, slip & falls) to L&E without the experience? Anyone do this successfully?

like

Hi,
Currently working as a assistant systems engineer in TCS. Current experience - 0-1 yrs.
I want to switch to sde, frontend roles. I am not getting responses. Can anyone help in this what i may be doing wrong?

Thanks

like

Hi Fishes,

I have a offer from Quebec, Canada as a Senior Frontend Developer(Angular) with yearly base salary of 100k CAD plus 14k CAD as Equity.

They are offering relocation package for both me and my spouse (she can apply for open work permit there).

I will be having a restricted work permit.

My Current CTC in India is 16 LPA.

Also they are asking me to join remotely till my work permit comes.

Should I go ahead or wait for the work permit ? Is the offer enough to sustain there ?

like
like

What are some items that have surprised you to be out of stock during this pandemic? I’ll start: everything home gym related, hair clippers, Tartine Bread book.

like

Stuck in a weird limbo where I want to leave my job more than anything but grateful that I have one at all with all the layoffs in our industry. It's a new kind of trapped. Anyone else feels the same?

like

I like to think of things incrementally… have been on a real health kick for 3 weeks. Started w keto, refined that to be kept with calorie deficit, added strength training, added long walks for low intensity steady state cardio. What would you add next? Some hiit? Stretching yoga?

like

Does anyone understand what the heck is going on

funny

Any IAM 🐠 in Chicago looking for an industry role? Less technical, more focus on strategy and transformation.

like

Privacy fish - Anyone taken the CIPM and can share what the exam is like?

Content outline seems like application of standard consulting approach, so how do they test it on an exam?

Hi, my friend is trying to do a start up in the UAE and was wondering what would be required of him on the cybersec end. I’m pretty fresh in my career and have only done IAM so I’m not sure how(cont.)

like

Additional Posts in Investment Banking - IBD

Is index match still used or has it been replaced by x-lookup? New analyst here having to learn index match (which is fine) but I always thought xlookup is superior.

like

Director level bonus %? Is it 1.5x?

likehelpful

Any thought on SVB Leerink TMT? They poached the entire UBS tech I think. It seems like a brand new group and the recruiter said to me that it would be a great opportunity but I am curious to hear your thoughts about joining a new group. Thanks!

like

Could someone please suggest how to handle this situation?
My manager (Technology Director) sees me as an emerging thread to his position and stopped sharing details / trying to avoid including me in visible projects etc.,
FYI - His manager is the division head and Managing Director.
Why I think my manager tries to move me out?
- I am 18 YOE with a technically strong background
- Upper mgmt is starting to identify me as the backup for all systems. My manager tries to move me out since then

like

About to leave soon for PE - more so because I wanted to try it out instead of stick in banking. Unlike a lot of stories, I actually love my group and feel really guilty leaving - my seniors genuinely care so much about me, but ultimately I’ve closed enough deals where it’s just repetition and I don’t want to wake up 40 one day with nothing to show for my life except 20 years crankiin the office and whatever many deals I’ll have closed by then. what’s the best way to go about breaking the news?

like

Anyone here from Truist hear anything about base comp raises to keep up with rest of banks?

like

Is it possible to lateral from a Corp Dev role to an IB one?

like

Piper Sandler culture in 2021? Any improvements from the sweat shop article in 2018?

like

Can anyone who has recently lateraled to a different investment bank speak about how their interview(s) were? How many were there and what did they ask you? Is it mostly deal related questions or did you have to memorize the guides again?

like

How to best prepare for analyst lateraling modeling tests?

like

What are your base salaries as analysts like? Mine is 105K.. curious to hear market for a first year

like

What’s the perception of Lincoln in the IBD space? Are the exit opportunities on par with other MM programs into HF or PE?

like

What kind of personality do you have to have to thrive in IB ?
Do you need to have the ability to chew out people built into you or can it come through experience?
Secondly, everyone says that IB is a 60% sales game and 40% number game. But who do they talk to ??
At a junior level, wouldn't you be just doing grunt work and not closing deals with clients ?

like

Best work time saving hacks?

like
like

Any firms known for having a relatively decent WLB even if pay is a little less competitive?

like

Recent grad who started at a boutique focused on MM tech m&a in the Bay Area. Is there anything else I should keep in mind when preparing to lateral besides staying active on deals/getting a good performance review and networking/prepping for interviews? It’s not that I want to leave my firm right away, it’s just that I know I don’t want to stay in the area for more than a couple of years and know that lateraling is an inevitability for me.

like

IBD fishies, what are the underlying differences between leveraged loans and leveraged bonds? Thank you!

like

Dunno if any others in IB can relate to me

I've been going through a rough time personally and have severe depression. But given we're still early in the year, and I think also the keener in me, I'm somehow hesitant to take time off to give myself a mental health break because what would 1-2 days off really do?

like

I need your help guys. I'm a Real Estate Financier in London for new development projects and have just been offered a new role with another company. The base increase is £20k however the bonus structure is c.£60k higher if I achieve targets less than at my current company.

I'd have to work in the office 5 days a week though and at present I don't need to at all.

Flip side is I have been offered a directorship at my current bank and I am 30. New wage TBC.

I have 2 toddlers and a puppy.

Help

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