if statement excel

Explanation: There are 4 Sub-inventories an item can be found in*. Staged to load (STG), International (INTNL/FGINT), an over-flow warehouse (PARG), or in the racks (FG). An Sales orders are labeled International (Open Orders 1 sheet Column E), and the the Status of the order can be found in...

HI All, I am trying to create a calculated column using an if/and DAX statement in PowerPivot and for some reason I keep getting errors so I am not sure if its the formula or if I am completely unable to perform what I want. My formula is below, can someone please help =IF(([Actual Order...

Hi Guys - I have been trying to make this formula work for a very long time. Following is the formula: =IF(AND(B2="Yes",X2="3000",AE2="SG&A"),"SG&A"),(IF(AND(AE2="R&D",AK2="Not Applicable"),"R&D -Non LOH"," "),(IF(AND(AE2="R&D",AK2="Yes-Yes"),"R&D - LOH"," "))) There are multiple conditions...

Hi all, I work in a business where we have a date driven process. As happens with all data, however, sometimes entry errors happen. I want a formula that will check to make sure that the second record date (AE) is not greater than the first record date (AC). However, when I write the formula...

I am stuck on an if statement formula. I hope someone can help. I have a list of fruit options in cell A1. I need a formula that will display the price of each fruit selected in cell b1. So If "Apples" Are selected from cell A1, the price that will be shown in B1 is 5 If "oranges" are...

Hi all, I am struggling to find the correct IF statements for the spreadsheet located in the below dropbox link. The issues I am trying to overcome are: 1. Column H (Decrease) - I would like this cell to equal one of the decrease values in cells N4 - N9 based on if the value in Column J...

Hi I'm trying to write an IF statement that will tell me if 3 consecutive zero's appear in the row of another worksheet. I also need the statement to tell me if there are more than 3 as well.

I have the following code in Column H. Sometimes I have the letters "ID" entered in some of the cells in the F column. Of course when I do this I dont get a value in my cell in column H. Could someone help me adjust the formula so I can still get my value? =IF(E151+F151+G151,E151+F151+G151,"")...

Sub test() Dim f As String Dim ab As String text= ThisWorkbook.Worksheets("Sheet1").Range("F1").Value filter = ThisWorkbook.Worksheets("Sheet1").Range("AB1").Value If text = filter Then ThisWorkbook.Worksheets("Sheet1").Range("S1").Value = "xxxx" End If End Sub I have code like that, but...

The title is perhaps not very clear and not sure if this can be done - BUT any idea how I allocate something a reference number but meeting certain criteria. What i'm trying to do is to say if the product (col B) is live (status col A) and has a certain code (col C) allocate the first...

Hi Guys, Is it possible to use a if statement with the Logic_Test is another cell? For example in A1 I have entered = >10 I am trying: =if(12=A1,1,0) but doesn't work ... Any help would be really appreciated

Hi Guys, I was just wondering if anyone knew what the sum was for =E2(IF("",NA,(TODAY())) I have tried entering it as an array but doesnt seem to work. Basically I just want it so if there is a text value in E2 return todays date in C2 if not it will return NA

Hello Please assist me in setting up a formula for if statement alongwith vlookup. Here are two tables: I would like to populate PAN number on the sheet 2 if my PNI and First Name Matches, If not then I want none value as a result. Sheet 1 <colgroup><col><col><col></colgroup><tbody> PNI PAN...

Hey everyone, I have created a macro to copy information from one workbook and paste in another. I'm putting in If statements and the only problem is that I cannot figure out how to get the macro to go to the next empty row if the condition is met for both of the if statements. Please help me...

I have a workbook with a Worksheet title "Trip Ticket Log". I have 5 worksheets title "PSPC", "CCG", "COMMS", "IT", "IM" On the "Trip Ticket Log" sheet Column G has a validation pick list that correspond to the name of the other worksheet (PSPC, CCG, etc) What I want to do: IF 'Trip Ticket...

Hello...new user...limited knowledge of VBA. Here's my question...I have a macro started like this: Range("S5").Select ActiveCell.Value = ActiveCell.Value + 1 Range("U5").Select ActiveCell.Value = ActiveCell.Value + 1 Range("M2").Select If H1 = 1 Then ActiveCell.Value =...

Hello all I am having an issue with a formula in my spreadsheet. I have run out of thought on my formula. Background. I have stores I'm looking at for periods of time for sales comp. That information is in cells A-K. Column L is a pretty straight forward formula to tell me if the store is...

Hi All I am trying to use an If statement to return a particular amount if a corresponding cell, on another table has a date (only - if it contains anything else i need it to be blank. Here are the tables: Table 1: <tbody> Initials Day 0 Day 7 Day 14 Delivery $500 $300 $800 $1500 M001...

I have an IF statement issue that looks at two separate columns, one column is equity into a project and the other column is loan into a project. The equity dollars must go into the project first and then the loan dollars would pick up. I need an IF statement that will automatically switch from...

Hi all, I need some assistance and I am fairly new to VBA. I am trying to create a macro that will open a workbook search a column for the first blank cell and copy the data in the cell next to it. Example: IF Range(B1:B100) = blank then Copy data from Cell.offset(0,-1) Paste into a specific...