if/then

Hello! Looking for a formula or VBA to help with this. In column L I have a list of dates in order but some dates might be missing (ex. 12/11/15, 12/12/15, 12/14/15). If a date is a Monday followed by a date that is a Tuesday, then 250 needs to go in each adjacent cell for Monday and Tuesday...

I want to embed an ‘isnumber’ within if/then statement to place the dollar value of a column into another column. Even though I can see the two characters I am looking for (VT), the formula continues to come up as “FALSE”, and I suspect it is because of the format of the cell that contains the...

Objective: to show days late, based on a projected date vs today's date UNLESS a completed date is showing in a different column Current columns: M4: has TODAY() formula to display today's date M10: no formula. Projected Meeting Date is entered here N10: no formula. Actual Meeting...

Hello - I'm new to Mr. Excel - please forgive me if I do not yet have the forum etiquette down. Let me explain what I do currently have correct.... I have 2 columns (Column N has a "projected meeting date", Column O has an "actual meeting date"). I also have one cell (N12 with the "TODAY"...

Hello, I am trying to use an If then Statement so that if certain text is selected in a data validation dropdown a certain value or formula is output. The output I use is just as an example. I have just not been able to get it to read the If statement. Sub Sheet2() If Range("B11").Value =...

I need to formulate something that will look up by part number (Columns A) to put an X under the Vendor names in Sheet 2 to show which of the part numbers we've previously purchased from each vendor (column L in sheet 1). I know index match will look up by two values (part number and vendor...

I've got a rather sticky situation with a spreadsheet that is calculating sales commissions. 1) Within my spreadsheet, I have a tab (COGS List) that contains all of our inventory items (by item number), their cost, and their price (Columns A, B, and C respectively). 2) I have another tab that...

Hi, How do I set an if/then statement for a result between two values? I have a value in A1 that will change periodically and I want the cells beneath it to reflect that change (this is part of a greater summation scheme that's already been set up): A1= 2 A2: if (x<1, A1, 0), this one is easy...

Hello, I have a particular set of data: AA BB AB CC CA CD DA FA FD FC I want to create an if/then statement to delete all values that contain either an "A" or a "D" for purposes of eliminating irrelevant data. What would my statement look like? Thanks in advance!

I am attempting to filter an excel spreadsheet and use IF/Then statements. I have searched this site (and google) high and low and cannot find a solution. Basically what I need to do is filter all items with a quantity of <-24000 or =-1 Then if the quantity does equal -1 I need it to filter a...

Hi I am looking to create a formula or "event" where when a Cell is clicked it takes you to another area of a different sheet for further information, I know this can be done with a simple hyperlink but due to the sensitivity of the material I need something additional to happen. Basically I...

Please help. I have been researching and have been unable to find the correct solution. Situation: Column A has 1000's of qualitative survey responses. I would like to label / categorize the survey responses in a corresponding cell. For example: If Cell A1 contains: "shirt","pants","hat"...

I have a workbook with two Sheets (sheet1 and sheet2) that each have 2 columns of data. Column A is a unique ID and column B is a date. I need to do a vlookup for a matching ID in column A and then compare column B values. If sheet2 column b is < sheet1 column b then I need to update sheet1...

I am using the percentile function within an array. If I use it in conjunction with with an "IF" statement, I get the wrong result. For example, this formula returns the correct calculation (it's using a much smaller data set than actual). {=PERCENTILE(L2:L8,0.02)} However, if I embed this...

Hello everyone! Thanks in advance for any help you can offer me. I'm trying to create a budget that autopopulates based on info entered into my checkbook. I have categories attached to each checkbook entry. I want the budget to create a sum based on both the category and date. So for each...

Hello, I am using the following code below to filter a column and color the rows of that contain cells with the correct values (this occurs 3x in my code). My problem is the if e is nothing then the column still colors. I only want the rows to be colored if e is not nothing. Any suggestions...

Hey folks, I've run into a bit of a conundrum, and I'm hoping you can help me. I have a chart that lists various employees, and how much they charge for 3 different types of clients. The three types of clients are large, medium, and small businesses, and each of 14 different employees bill...

Here's a much shortened version of my spreadsheet... where the numbers are meaningless... jim 100 400 600 jim 200 300 800 jim 150 250 350 pam 100 200 300 pam 100 200 300 tim 200 300 400 tim 400 500 600 jim and pam are just 2 of the 17 employees in the Cash Applications...

I'm struggling to Set a variable based on an if statement. What I want is to set the variable User = Environ("USERNAME") if the Environ("USERNAME") does not equal userB or userC. If the Environ("USERNAME") does equal userB or userC then I want User = userA. Here's what I have however I'm...

My worksheet looks like this: ... C D E F Complete # # # Building # # # Burning # # # New # # # Each time "Complete" is marked in column C I need for column F to be 0, but when C is marked as one of the other...