# logic

1. ### Nested IF...THEN formula with multiple conditions: Rule of thumb on sequence logic?

When creating nested IF...THEN formulas, is there a rule of thumb you use to design the logic sequence of conditions? I'm trying to address five conditions using a nested IF...THEN formula and could use some guidance. Alternatively, if you have suggestions on addressing five conditions using a...
2. ### running average based off month

Hello, I have a table that I want to keep a running average off of based on month. The table looks like this: <tbody> Month Score 1 0.92 2 0.92 3 0.89 4 0.91 5 0.91 6 0.81 7 0.88 8 0.89 9 0.83 10 0.86 11 0.94 12 0.93 </tbody> I want to keep a running average from...
3. ### Excel Formula - compare two set of cells and find return the result based on the logic

<tbody> A B C D E (RESULT) 1 10 10 5 50 Y 2 20 20 1 1 N 3 10 10 N/A N/A N/A 4 N/A N/A 2 3 N/A </tbody> Need help with this as well. Logic : C>A OR D>B = Y else N if N/A present in A&B or C&D then result is N/A
4. ### Logic Function Question

Hi Everyone, I have this formula that I use to pull a certain data while referencing certain cells.... Here is the formula: {=IF(B419="","",IFERROR(INDEX('Work Orders'!N:N,MATCH(1,IF(VALUE(D419)='Work Orders'!AC:AC,IF("Canceled"<>'Work Orders'!K:K,IF('Work...
5. ### Delaying production

Hi there, I have a large excel model with multiple assumptions behind it. It works on a 250 month basis so is quite large and there are several types of production curves in the model. What I want to do is to be able to set a delay on when the production starts for each production curve. So...
6. ### Sort by most efficient combination

Hi all, Not sure if this is best done via excel solver, formula, or VBA, but I have the below problem: A cell setting a maximum size, set in this example to '25'. A set of numbers, which cannot be split, only combined, to fit into groups equaling 25, e.g.: <colgroup><col width="64"...
7. ### Simplifying if logic

Can someone please help me tidy up this logic? If ConditionA Then If ConditionB Then Call SomeSub Else Runverylongpieceofcode End If Else Runverylongpieceofcode End If I don't to write Runverylongpieceofcode twice. Thanks
8. ### Is it possible to grab logic rules stored in Excel to use in VBA If statement

Hi All, I am trying to automate updating a series of spreadsheets. The data is a forecast summary. In some worksheets, the data may be rolled up and presented by a family group, others may be by sub-families. In some cases, the top families are summarized individually and the smaller ones are...
9. ### If Logic

Hi, I have an if statement that is not quite working for me. Here is the code: =IF(ISNUMBER(AND(SEARCH("Comp",D27),Dashboard!\$H\$16="Yes")),IF(E27="WD","No",IF(AP27<=2,"Yes","No")),IF(ISNUMBER(AND(SEARCH("Open",D27),Dashboard!\$H\$15="Yes")),IF(E27="WD","No",IF(AP27<=2,"Yes","No")),"No")) It...
10. ### Logic Table Newbie

Hi- New to VBA and trying to perform a function to analyze a 3 column logic table based on certain conditions and then return a text value in another workbook. Logic table and desired output will be in same workbook, different sheets. Logic table Sec Type...
11. ### Nested IFS/Multiple Formulas

Hello, I am seeking help on the following problem: <tbody> a b c d f g h i j k l m n o p q 1 Upgrade 1 Upgrade 2 Upgrade 3 # employees Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2 Jan Feb Mar 3 </tbody> I need to write a formula for cells F2:Q2 that calculate the...
12. ### Help create a Shale chart

Hi, I have (410 line) data like the sample attached below. Need VBA code to create a shale chart. With Unit being the various areas and End by being the X-axis. Logic: All units put together totally there are 410 people. With 17 people having end by P1, 410 will get reduced by 17 in P02. this...
13. ### Formula/Logic Writing

Hello, I am building an inventory production schedule and need help writing a formula for the following logic. For example, in Row A, Column A:L (January-December), I have projected sales of 25 units per month (starting in June). Additionally, my minimum monthly production order is for 30...
14. ### Complex combination of IF/AND Formula (Help Needed)

Problem Statement: I am having difficulty creating a formula that will take multiple AND and IF criteria into calculation based on today's date. Please see below for (4) logic statements that I have been trying to incorporate into a single formula string. Column E is the output. (Where the...
15. ### VBA Help: Using *Insert Row* to adjust distance between random distance of Row A to cell containing "ID #"

I'm a bit new to VBA. But, I've gotten pretty far into this project at work. However, I've come across a logic problem that I don't have a knowledge base wide enough to complete: The problem goes like this: I have many Work books that I need to export to a master WB one at a time (this wb then...
16. ### If then Statement

Hi, I have 2 columns Column 1 (CT_Flag) Values: RM, V, EE Column 2 (VB_Flag) 1,0 I need to create a new column with the following logic: If VB_FLAG = 1 then CT_FLAG = V else CT_FLAG Any idea how to get this to work please? Thanks
17. ### clearing the whole sheet except first row

Hi The code below is to clear the whole sheet except the first row. Rows("2:"& Rows.Count).ClearContents I am unable to understand it. I would appreciate it if you can break it down so I can understand the logic behind it. Thank you so much
18. ### return non blank values in a row with additional logic

Hello Everyone, Seeking for assistance to help solve scenario below... I am looking for a formula which would return a non-blank value in a row and cover some additional logic: 1) if the row has one value (i.e. ROW 2 / B2) return that value 2) if the row has two or more values (i.e. ROW3 /...
19. ### Excel 2010 Attendance sheet Fomula for time Value

Hi, Id like to ask for your kind assistance on this, im trying to create an attendance tracker which would determine the employees schedule and the hours he covers, now will it be possible to automatically fill the the hours by using a formula just by putting the employee schedule under the...
20. ### Date Difference with year and month (Formulae)

Hi Friends, I need the output as shown in column D(Expected Diff) with basic If calculation. Logic should be simple not much complicated as I will use the logic in some other tool for performance consideration. (Left, Right and Mid should be avoided if possible). Any thoughts ...

### This Week's Hot Topics

• SUMPRODUCT active link formula
Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox... ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?    ### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back