if statement

Looking for a possibility of making this formula shorter, any ideas? Thanks =IF(AND(INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),7)=0,INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),8)>0),INDEX('Tab2'!$F:$M,MATCH($F$3,'Tab2'!$J:$J,0),1),"") This formula is producing this The active cell is A6...

Hi, I am hoping you could assist me with a formula I need. K2 has a drop down list with the following options; 12 month nomination or 2 year review. K36 needs to be able to calculated based on the option selected above. e.g if 12 month nomination is selected then K36 needs to divide K35 by...

Hi Everyone, I'm trying to figure out a formula to show if a request was rejected or approved. We make trackers twice a day and the only way to notice if a request is rejected, is if it shows up twice but with a different date. Providing example 135969 HIERARCHY HIERARCHY ARTICLE_CHANGE...

Hello, I am new to this so please excuse my ignroance... this is my first post... I just have a question I want to create a macro that cuts data from a certain range in one sheet and then pastes that data into another sheet if one condition is met. So I have attached this spreadsheet as an...

Hello, I can't figure our correct formula for this problem: The primary key has multiple costs, that are displayed in columns "Item1, Item2 and etc." I want to assign VAR that multiplies primary key sales amount with either Item1, Item2 cost The condition should check each Item column and...

Hello and Good Day! I have an issue with writing a proper conditional formula in Excel, so please help me Elaborating my issue, Column A are Fruits; They either have "Oranges", "Apples", or "Pears" Column B are Client's Names I'll input the gross income on C Result for net income will be...

Hi all, I've nested an if and/or formula and all seems to be working well except for one odd result. I was wondering if someone could help. Attached is a screenshot. The formula reads as follows for row 3...

I am trying to write a formula based on the following conditions and it is not working IF A1 = "S", and B1 = 254 or 127, Use LIST NOLIST IF A1 = "F" or "M", and B1 = 254, and C1 is even, Use LIST EVEN254 IF A1 = "F" or "M", and B1 = 254, and C1 is odd, use LIST ODD254 IF A1 = "F" or "M", and...

Hi, I have these VBA code that I run through each range to divide and insert if formula. Initial it has no issue, but now I have new lines, which I do not need to insert the formula if column E (Qty) is empty. And I do not know how to apply the command, if column E is non blank, then apply the...

Hello everyone. Given: Range("P2").FormulaR1C1 = "=IF ( AND ( RC [-7 ] > RC [-6], R [1] C [-7] < R [1] C [-6]) ,""Text message"", """") ) I've been trying to insert value (Number) of the cell RC[-6] (from the same Row) instead of "Text message" but I could not succeed and I don't even know...

Hello! I am attempting to use the BeforeSave event to check whether any of the checkboxes are selected before allowing the user to save the workbook. Please see my code below. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) MsgBox "Entered Sub...

A B C D E F G H Reporting Date Invoice ID invoice payment id invoice header id invoice terms date vendor number po/non-po flag supplier name 23-Apr-20 1900057573_5430_2020_0001064077 1900057573_5430_2020 0001064077 NON_PO GT TRANSPORT 2012 CO LTD 23-Apr-20...

Hello, im having trouble with coming up with a formula for the following case: We have sheet with data about different products: Product Quantity Location Product 1 5 1-1-1 Product 1 10 1-1-1 Product 1 5 1-1-2 Product 2 10 1-1-2 Product 3 5 1-1-2 Product 3 10 1-1-3 Our...

Hello guys, I have this code of mine in the Macro (And yea, I tried using the classis "i" as a variable, did not work so I changed it to "g") For g = 1 To 20 If (InStr(1, salesWS.Cells(g, 2).Value, "X004a", 1) > 0 And InStr(1, salesWS.Cells(g, 3).Value, "TOBI", 1) > 0 And...

Ideally I would like the message box to display whether any discrepancies were identified in sheet 3. The data in sheet 1&2 should be identical, so when the macro is run the results in sheet 3 should show no data because there is no discrepancy. Now, if there are discrepancies between the data...

At the end of running my macro I would really like it if a message box appeared displaying the results of the macro. The message box would say "X" number discrepancies were identified, or "0" discrepancies were identified. I am having great difficulty making this happen, i would really...

Hi, After previously having a huge amount of help via this forum previously I’m hoping one of you excel gods wouldn’t mind looking at another thing that’s got me stumped. So I’m trying to identify where a telephone call has been made by an agent during a time period they weren’t supposed to be...

Hi there, I can't work out why I can't join these two IF Statements. Separately, they work fine. =IF(J40<3.5%,"Acceptable Variance (Does not exceed 3%)","Unacceptable Variance! (Exceeds 3%)") =IF(J40>-3.5%,"Acceptable Variance (Does not exceed 3%)","Unacceptable Variance! (Exceeds 3%)") But...

Hi there, Cell H15 is formatted to text and has the following formula in it; =IF(F15<>0,426,"") I have other formulas (INDEX/MATCH/VLOOKUP) which refer to cell H15. If I just type 426 into H15 everything works fine, but if it returns 426 through the IF statement above, it returns errors on my...

I am trying to AutoFilter (in column A of SHEET 1) the Active Cell in SHEET 2. Then I have an IF Statement that counts the number of Visible Rows, and if it is more than 1 (to exclude the header) then I would like to insert a new row into SHEET 3 and cut and paste the values of the Auto filtered...