nested "if statements"

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!

I am attempting to create a formula in B6 that considers the following criteria: If SUM B1:B2 <100 then SUM(B1:B3)*28 If SUM B1:B2 >100 then multiply the first 99 hours by $28 and every hour worked thereafter by $32. Then add B3*28. * B1 & B2 are the only hours to be considered regarding <...

I’ve done a nested IF, contains 4 or 5 criteria returning a Yes or No. Why would it return a True or False when adding an additional criteria if I’m returning a Yes or No and presenting incorrect results?