What is wrong with this formula =if(>=threshold1,b2*yellow_high,=if(c2>=Threshold2,B2*yellow_low,”no action”))

At first I wondered why everyone in my office was married to/dating each other. But now it makes sense, they're the only people you ever freaking see 😐

PDM specialist at 96k. I have an option to select PDM Specialist 2 or PDM Manager for my promotion with the PPMD. Which one is advisable to prefer Pay wise? I am thinking to take PDM 2 to increase my base pay for the manager.

Let's have a meetup in Pune? I think there will be a lot of people shifting in now from different cities, especially bachelors, and outside of AYDE and stuff, I think this will be a good way to meet each other. What say?

Hi, how may days after HR discussion i can expect offer letter?

Working at a hospital with a million programs and services. When is developing an independent brand for a group justified, and when should it remain part of the parent brand?

Hi! What's the difference between Product Strategy, Corporate Strategy, S&O, and BizOps? Thank you!

What’s the difference between product marketing and product management at Facebook? Or any company? And product strategy …. So confused!

Hello wanted to move from enabling areas to consulting for SAP FICO any leads please let me know

This veteran just finished his last final (on the first day of finals week!). Commencement next Monday. Will take a few months off to hang with my family and start at PwC in the fall! Time for a beer

Looking to return to singapore from the us. Spent the last 10 years consulting in the us - 4 with ibm and 6 with slalom. Any tips on which firms to target or avoid, based on prospects and culture?

Hi All,

Can anyone tell me the salary structure in IBM?
Compensation team told my variable will be 10 to 15% and there will be quarterly bonus depending on performance it seems?
Is this true? IBM

Best Regards

I was wondering how do other trans and non binary people find their boo.. the dating apps seem unreal and in person events are not that frequent.. DM me

Serious question: I know I am an attorney but this so outside my area. I was rear ended about a year ago and I need to either settle with the insurance company or sue them. Could someone provide some guidance? I really really need some help with this

Does experience in financial due diligence with Big4 ensure good future opportunities ? Also how good is it for an MBA finance considering the majority of crowd I have found being CA on LinkedIn..

TIA

I've been working at a government agency for 6 months, helping to stand up a new team. The job involves interacting with real estate developers. One of the developers reached out to recruit me for a similar position that will pay more than $50k my current salary. I feel guilty, especially since I'd interact with my current team on the other side. It's a hard to turn down that salary, though I feel guilty since my team is thin, and it's only been 6 months!

Any tips on navigating this situation?

SCORES ARE UP!

What is the percentage of hike you get on getting promoted from senior consultant to principal consultant in pwc india. Will they do a market correction of your salary is low.

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?

Would anyone be willing to teach me vlookup?

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?

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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 anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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.

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).

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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

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 ...

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?