Is there an easy way to see a +/- 10% on all of my variables in a model? Is the easiest way just using a formula and creating separate columns to visualize it

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

Assuming your are just looking for a flexible way to display the results:
I would probably create a separate cell with a sensitivity assumption (e.g., cell that has 10% hard coded into it) and link all my variables to it (variable = [formula] * 1+[sensitivity assumption cell])

That way you will be able to toggle across different cases quickly and build a data table highlighting sensitivity

Obviously might be more challenging depending on how your model is built, but should do the trick

like

Related Posts

Hi All. What would be the monthly in-hand after tax?

Post Photo
like

Filed itr on 21st june, any idea when i can get the return

like

Do we get our tax deducted refundable? I have submitted my IT returns on time?
Pls advice..

like

Hi Fishers,
Can you please help me with take home for below offer, Declared HRA for 96000 in investments.

Post Photo
like

Is office going to open and be compulsory to attend from Jan?

like

Any OTC recommendations for dandruff shampoos? (Seborrheic Dermatitis)

like

Any Florida or Georgia fans around? I am not a fan of either team. but love big rivalries and want a good game.

Today I learnt abt Quranism. And I'm genuinely frightened by it. May God guide us all and forgive our shortcomings.

like

What's with the awful delay in publishing the new visa bulletin?

like

CONFESSION I turn the dishwasher on every night with the same four dishes and my coffee mug I bring to work in it..... #CantHumanToday #SleepOverEverything

like

What is appropriate to give your assistant and paralegal as a holiday gift? Want to do something nice but do not want to offend.

like

Question for PWC 🐠 -
Being poached for People Analytics role (SA), since you have a cohort model, how does negotiation work? What’s the cap for McLean office with 3-4 YOE? Not wanting to take a cut

like

Will there be any hike if I moved to associate 2 in pwc ac, if yes how much can I expect?

Need a pep talk! I've gotten into the habit of snacking/eating out of boredom or when procrastinating, so I decided to mentally hit reset and do a monk fast today (36hrs, not my first one). I'm soooo hungry though 😭 trying to stay strong

like

How do you guys deal with megalomaniacs at work?

like
like

Suggest any killer ab workout!

like

I would like to get a certificate to make myself more marketable (I do tech strategy and would like to continue with this capability). What certificates do you recommend?

helpful

Can anyone recommend a psychic in NYC area? Serious replies pls.

funnylike

Hey guys, anyone happen to know what Quest migration manager licensing is like these days for say 5K users?

like

Additional Posts in Excel Genius

I have been given a csv file and one of the columns has multiple properties. I want to split each of the properties into their own column. However every row doesn’t always have them in the same order and may have slightly different properties. Is there a way to sort this efficiently?- picture for reference, columns v onwards is how I have split with text to columns currently. Any help is greatly appreciated

Post Photo
like

Help!! Time-sensitive:
Please tell me how I can achieve this:

To create concatenation of every possible combination of Type to Price for every ID.
I provided an example below with the outcome I want in the second table. Would prefer if this be down without a macro.

Post Photo
like

Just here to praise the Unary Operator. Old school programming trick that’s still very relevant.

In Excel it’s =--(Range =or other logic op Condition)

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

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

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

like

Anyone hit a manual on how to do EVERYTHING in excel 😭? PDF or something

like

I run a chatbot that collects students inquiries and want to spot reoccurring questions without going through all 4,000 questions. So far, I’ve created an advanced find keyword indicator to help bucket questions into themes, however I want to build an FAQ sheet. All/any help appreciated 😅

like

Feeling behind at work. I’m relatively new to data/financial modeling. Any advice on learning how to take a client data set, cleaning it up, and turning it into a model for analysis? I’m a new consultant at a boutique and I’ve basically received no training at my company on how to use Excel to do this. Additionally, is this fair game for a new analyst to understand how to do this without any prior training?

like

Does anyone know the best approach when dealing with Ad sales linear and digital in Analytics? Or any knowledge about the ad sales industry

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Is there a way to add 3+ criterias into a vlookup and if there are multiple results, to list them in different cells?

like

Hey, anybody good with pacing forecast?

like

Is there an easy way to create flow chats and diagrams in Excel without the Visio add-in?

like

Looking to use an XIRR formula with an “As of” date option (as of 12/31, 9/30, etc…) So it would essentially stop pulling dates and values once it hits the date in the “as of” date cell.

Any ideas? Much appreciated.

like

Alright. I am very much so not an Excel genius; I have the Excel skills of your 90 year old grandma who just owns a Jitterbug. Im semi-tech savvy (young millennial), but I’m new to corporate after transitioning into my role from the classroom. Among some skills I know I need, understanding basic Excel functionality is the most immediate. Does anyone have any recommendations for a very novice look into Excel? Thank you in advance!

like

Is there a way to add trend lines/fitted lines for each category on a bar chart? Looking for something similar to below.

Post Photo
like

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

like

Wait … xlookup is basically VLookup and Index/Match?

Is this seriously a viable alternative because what the hell have I been doing with my life?

likefunnysmart

Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

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