ifstatement

Hello - I am looking for help with the following. Thanks in advance! I have a column with values that need to be categorized based on multiple criteria. I would like to categorize using below logic: If value contains "X" Or "Y", categorize as "Category1", if contains "A" or "B" or "C"...

Hello, I am to figure out if it is possible to use a calculated column in a measure. The Calculated Column counts number of accounts per user: #ofAccounts =IF(ISBLANK(CALCULATE(COUNTA(Accounts[Contract Id]),FILTER(ALL(Accounts),Accounts[Contract Id]=Contracts[Contract...

I am struggling to put a formula together for the below set of inputs: <tbody> Target achievement % payout 90% 0 95% 50% 100% 100% 110% 150% 120% 200% </tbody> So if the target was £1000, and they achieved £900 they get nothing, if they got £1100 they get 150%. I need to know the...

Hi Guys, I am trying to develop a formula which can help me do the following: 1. Looks up for two specific values in two separate columns 2. Looks for the first value in a third column and also looks for the second value in a fourth value 3. If both the first value and second value are found...

Hi, I have various columns including column F, J (both have dates values or no value/no dates) and U (which has a text value) I want to say that if at least one of the columns meet my criteria then, it shows the row as Active / Inactive. However, the function below only gives me inactive even...

Hello everyone, I have been trying to write some VBA code to check if a cell contains a positive, or negative percentage. Based on whether it is positive, or negative I would then like to copy and paste the value into a new table on a separate sheet which has two tables. One containing all the...

I am looking for help on an excel formula in which i would like to do two things. I have two columns, one with a five digit number (column A), then column B will have the formula. If the value in column A is either 20800, 24900, 59000 or 60000, i would like it to return a 'INVALID' value. Then...

Hello, I have some code that compares part of a filename to a list in a column then moves the file to a new folder if they match. However I can't seem to get the message boxes right. I want ONE message box to display "Files archived!" when the loop is finished and ALL the files have been...

Hello! I have a spreadsheet that I'm using with three different sheets (Sheet1, Sheet2, Sheet3). In Sheet 1 I have a dropdown list (C4) that contains 20 types of licenses. When a license is clicked, cells c2:c4 will autopopulate with what type of test the person needs for the license (there...

So I have a date formatted as MM/DD/YY and I need to determine the day of the week using the MOD function and a single IF Statement and I have no idea how to do this? Any help would be appreciated. Also the date I chose was 3/16/2016

Need some help with a formula and I'm going to try to formulate what I'm trying to achieve and write down the logic below in steps: 1) Take value in TABLE 1 and Lookup for matching value in TABLE 2 2) If value is found then go 5 fields across (to the right) and bring back the value (value are...

I crated random numbers between 0 and 100, and I want to convert those numbers to have a specific value from 1-6 depending on the random number value. Those specific values are the following: 0-30 should output a 1 30-40 should output a 2 40-60 should output a 3 60-70 should output a 4 70-75...

I created two columns with random numbers, however in the next column I want to use an if statement. For instance if the number in the specific column and row is between 1 and 2 I want it to output a "1". Likewise if a number is between 3 and 4 I want it to output a "2" and so on until I get to...

I am trying to find an easy way to distinguish duplicate values in a column. Then in another column/cell place the word "DUPLICATE". I cant seem to get the IF formula right. Who can help? So lets say I am trying to find duplicates in a range D1:D2000 then in another Cell place the word...

Hi - I am trying to loop through my code below Range("MonthCount2") times - which we'll say is 10. Within this loop, I have an IF statement, which contains a loop of "Multival" times - which for the first loop through is 2. My code does what i want (i.e. pastes the selection MultiVal times)...

Cross Ref: how to Use IF statement and Highlight & Message Box Pop up I really need to convert these to vba codes urgently I would like to highlight certain data (ID) and pop out a message based on the following IF statement I have two Workbook - Book 1 and Book 2 I need to check the ID (...

Hello, I am trying to make a cell display a certain date using nested IF arguments or Vlookup if that is more appropriate?. For example, When a date is manually entered into A1, B1 should then display another date that precedes the date in A1 by either 30, 60, 90, or 120 days prior to the date...

Hi, I have drawn the table which I am currently working on. I need the formula in B2. I can use the same formula I used in B1 but for B2 I only want it to count the number of No if there is a date entered in D7. I think this can be done by using an IF statement but not sure what the formula...

Hi I have drawn up a draft table of the spreadsheet I am currently working on. The formula in D3 works perfectly fine, it gives me a value of the number of days taken to resolve the incident. However, until the incident is open and there is no date in Cell B3 I need to check how long has the...

Hello all, I am currently having an issue with the below formula being pasted into a cell.formula as shown. If I take away the If(C12<>"", , ) then the formula pastes just fine. when I paste the formula directly into a cell, it also works perfectly. Is there a way to have the macro not worry...