Jun 2, 2018 · Good Evening, today I came across the following problem: Say we have a table where the a-column is for example the color of a car, the b-column who sold the car and the c-column is the price it sold for.We now want to multiply the values of all red cars sold by Peter and here lies the problem...

Sep 13, 2017 · Handling multiple conditions in an IF formula. This article compares the three different methods. When you need to do a conditional calculation, the IF function is the answer. If <something is true> then <this formula> otherwise <that formula>. In the following figure, a simple IF calculates a bonus if your sales were $20,000 or more. Bonus Calculation with IF But what happens when two ...

Jul 1, 2024 · When you need to do a conditional calculation, the IF function is the answer. It works like this: If , then ; otherwise . In the following figure, a simple IF calculates a bonus for your sales of more than $20,000. Revenue is in column B. Pay a 2% bonus if revenue is greater than 20000 with =IF (B4>20000,0.02*B4,0) But what happens when two conditions need to be met? Most people will nest one ...

Feb 5, 2020 · Hi all, I have three dynamic indexes of data and I am using the mode function below to identify what is the most frequent Data_Reason and populate that outcome in another sheet. Now I would like to expand and include another criteria from Data_Team list, so I can populate results by team. So in...

Jan 5, 2022 · Hey guys, I need help with my formula: =FILTER (TDB, (ISNUMBER (SEARCH (F8,TDB [Fund Manager])))+ (ISNUMBER (SEARCH (F8,TDB [Description])))+ (ISNUMBER (SEARCH (F8,TDB [Tags]))) * (ISNUMBER (SEARCH (F19,TDB [Verticals]))),"Not Found") When I added the part in bold, the formula ignores it. What I try to accomplish: (TDB is the name of a table I created) F8 and F19 are input cells where I want ...

Nov 20, 2009 · Hi all, Using Excel for Office 365 MSI 16.0.11 x64 version 1902. I have a scenario where I think TEXTJOIN would work, but I can't figure out how to concatenate several IF statements together. I have: - Column A (id) with hundreds of row entries, simple numbers 1-..... - Column B (category)...

Jul 10, 2008 · The problem I am having when using the quartile function is that I get the quartile for the entire range of data (6700 lines) and not just the quartile for the data that meets my conditions. How do I set up conditions on teh quartile function so that it only returns the quartile for data that matches condition 1 adn condition 2.

Nov 10, 2004 · How can you use the percentile function with two conditions? I need to find let say the 90th percentile of test scores for Male students from the state of New York.

Apr 8, 2002 · I want to use the FIND function to determine the position of the ' - '. I can do that OK. The problem I have is, the character I'm looking for will not always be the same. It will be either a space, a dash (-) or a slash (/). Can I use the FIND function with multiple criteria to do this? (Lotus 123 did this very simply with the #OR# function ...

Aug 19, 2020 · I have a product template in Excel, which I have reduced for this question. My business unit uses it to onboard products in a database. I would like some help in creating a vba function that I can assign a button to trigger. This is a screenshot of the template: Basically, I …