nested "if statements"

I'm having issues with this formula set up. Week Data Validation List 1-18 Team Data Validation List of Teams VS Long IF/VLookUp Formula So in A2, I have a drop down to select the week number, and in B2, I have a drop down to select a team. In B4, I have this formula. The idea is to...

Hello all! There has to be an easier way to accomplish what I'm after, would love any ideas. I am trying to write a formula that spits out a value based on what range the percentage falls in. I'm currently using nested IFs to determine if the percentage falls in between the ranges below and...

Hi This is my excel file I am trying to put a band automatically in column W but it is not happening What I need is that if an Employee salary is >= 15000 but less than 20000 then he/she be in Band "I" similarly in increments of 5000 till band "XV" However the above formula is sending an...

Hello all, I am a newbie with excel, so I'm hoping someone can help out. in the workbook I'm working on, I have multiple tabs with data spread out. Tab 1 contains a list of resources and the dates they will end support. Unfortunately, some list the full name, and others list just the first...

Hi everyone, I am very basic when it comes to excel, and thought I could figure this one out, but alas, I need help please. I have a drop down list in column E, cell that has the following options: Low, Medium, Medium-High, High, New Depending on on that choice, I would like to return a value...

Hey Everyone, I have gotten most of my formula to work but I need to add one more condition and I can't seem to figure it out. Here is what I have so far (that I've tested and works)...

I am using a formula in which the results "low", "medium, or "high" will appear (in column U) based on the numerical value that is entered in another cell (in column T). =IF(T3<>"",IF(T3<=59,"LOW",IF(T3<=79,"MEDIUM",IF(T3>=79,"HIGH","")))) It works perfectly, however the word "FALSE" is shown...

Hey All! I am running into an issue I can't figure out. I've got a big set of data and there is a specific column that I want to make a case statement based on the results. If the field, lets call it A1, is... =42 or =43 or is between 70 - 99, excluding 79 and 81 then I want to call it "Yes"...

Interesting one for you all - Excel 365. If I use a simple formula to subtract 1-1 I get, as you would expect a 0 (Row 2) However, if I nest this inside an iferror formula I get a very strange answer (yellow cell). (Row 3) Anyone any thoughts on why this is happening?

Hi, Hoping someone can help me. Currently i have 2 separate IF statements checking for separate conditions: First one checks if 1 cell is blank, and a corresponding one isn't and will result in a string of text: =IF(OR(ISBLANK(H2<>""),ISBLANK(A2)),"No Deal Reg - Contact Opportunity Owner","")...

Hello, I tried to add this last line IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5-TODAY()<1,"OVER","" To a function that was working. Now it says I am getting an error for too many arguments. Here is the new formala below. Please help. =IF('[EUCOM Revised SEMA...

I have data in col A (item) I need to know if it is repeat or new. the thing is, all item starts with 302 are new (N) item number, but if this item is repeating(starts with 302), I have to tag it as Repeat (R). i have the formula to find if it is repeating. =IF(COUNTIF($A$1:A1,A1)=1,"N","R")...

I have 3 categories (Priority, Less, None) that correlate to a specific NESTED IF Function but only differs in the percent within the calculation. Overall, the result of the use of the formula provides a Status of behind, ahead, on track etc. I currently have the status only populating with...

I have data in columns M through Z. Based on how many columns have data in a specific row, i want column B to give it a category. When trying to past the below formula into B2, I get window stating "there is a problem with this formula". =IF(COUNT(M2:Z2)=1,"1st to 2nd",IF(COUNT(M2:Z2)=2,"1st...

In Column A of my excel sheet I'm trying to create a unique, sequential ID in each row according to the 'activity type' in Column C. Activity Title is in Column B, but the two relevant columns for this example are Column A and Column C. There are three activity types: Milestones, Tasks, and...

Searching and trial and error have not gotten me anywhere, so hopefully, I can get a tip as to whether something is wrong with my formula, or if I'm using the wrong kind of formula(s) altogether. I'm working with a series of billing codes, and one has a different rate of calculation than the...

I built a PTO calendar dashboard where it automatically updates the employees availability for the day based on the calendar's data. The options vary from U (unscheduled), holiday, jury duty, covering, or a value over 1 is added. This is what it looks like: =IF(OR(VLOOKUP(N28,table...

Hello y'all, I've got a simple formula to identify if a date in W4 occurs within 30 days of a date within X4: =IF(W4+30>X4,"Readmission Present", "No Readmission"). I'm trying to expand the formula to have it include this date comparison for the next 24 rows. As in, also including...

Here is my code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$E$70" Then If Me.Range("E70") = "Yes" Then If Me.Range("E9") = "" Then MsgBox "Please enter school ID at the start of the form to continue"...

Hi! I have column which has several termination dates and what I need to do is to group those dates into years as showing below: - Less than 1 year - 1 year - 2-3 year - More than 3 years What is the best formula to use? Thanks!