if satement

Hi, I have a list of managers and their management levels and what I need is to validate if each manager has the right management level. The issue is not all the managers have the same exact management levels, i.e. some managers have 1 level and others may have multiple. I need a formula that...

I make use of the If statement a lot and sometimes the formula returns a 0. When the main formula returns a zero I want it to show the dash character so I usually make a formula like this: =If(*Formula* = 0,"-",*Formula*) My main question is if there is a way to not have to repeat the formula...

Hi All, I have compiled this code, but I want to tidy this up and if possible, have arrays so that it would be easier to add more variables in the future. In a nutshell I want the macro to look at Column AA for anything in the array AND if column AC has a specific text to then give me the...

I have a challenge, if anyone is kind enough to assist. I can probably put a formula together for 1 condition, but the mix of mileage/date has be stumped! I am attempting to create a spreadsheet for my boss that tells him if a vehicle is due a service. (I have been in this job 1 month and I...

Hi, We are trying to build a basic dashboard that is automated having to only paste in a raw data sheet that is cleaned and then uses the data from the 'clean data' sheet. At the minute we are trying to work out MODE of a text string within a range per week client activity is live. The...

Actual Salary (M9) Minimum (T9) 1st. Qtr. (U9) Market Rate (V9) 3rd Qtr. (W9) Maximum (X9) Quartile Position (Y9) 43680 31720 37010 42300 47585 52870 Q3 I am having trouble with the formula below: =IF($M9<T9,"Below...

Hello all, I am working on a league table in excel which follows these set rules to determine the rank of the teams. Points obtained in all group matches; Goal difference in all group matches; Number of goals scored in all group matches; Points obtained in the matches played between the teams...

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","")...

Hi, New here, so apologies if my explanation is not great: I am trying to get the following results IF A1 = "black" or "white" AND IF B1 - "yellow" or "red" or "blue" results: TRUE= yes FALSE = blank Cells A1 and B1 can have numerous varying text in there, but i want a result if they both...

I'm trying to write some code that deletes the unspecified columns based on the header and for one reason or another the code does not execute. wbDest.Activate lastColumn = Cells(1, Columns.Count).End(xlToLeft).Column For i = 1 To lastColumn If Cells(1, i).Value <> "Ordered...

Hi I want my code to exit as soon as the condition of the if statement within the for loop are met and the message box appears (shown in yellow below). When exit sub is added, it exits after the messagebox but the rest of my code does not run when the conditions are not met, and if I remove...

Id like to write a formula that has an if with more then one criteria but nothing seems to be working. =if(n1="ablation", i want to look in a table for two criteria and return the amount in column H.

=IF(J2>75,"3",IF(J2>65,"2",IF(J2>50,"1",IF(ISBLANK(J2),"none","0")))) J2 column holds the scores to a conditional test. Not everyone was given the test so there are some blank cells. IF the cell is blank them "none" belongs in the column if the cell has a number in it then the first IF...

I am currently using the below array formula to pull information from another sheet. I want to add an if statement to this to only pull the data if Type equals "Employee". I have already done this with the other cells that are not arrays but cannot figure out how to make it work with this...

I have three columns: E: ContainsL F: ContainsR G: Match ContainsL: =MATCH("*"&LEFT(B2,5)&"*",C2,0) ContainsR: =MATCH("*"&RIGHT(B2,5)&"*",C2,0) Match: =IF(E2+F2=2,"Yes", IF(E2+F2=1,"Yes","No")) ----------------------------------------------------- ContainsL and ContainsR returns either a "1"...

Good Morning Guys, I hope you are all well. I am just in the process of setting up a new part time employee on a Holiday Spreadsheet I have made which uses NETWORKDAYS to determine the amount of holiday the user is after. So when the User selects for example 12.04.17-13.04.17 that would be 2...

This below is the Sheet1 <tbody> Model Brand Status Quantity Minimal Quantity a1 Asus In stock 2 1 a2 Sony In stock 1 1 a3 Toshiba Test 3 1 a4 Fujitsu Test 1 1 </tbody> I want to separate in different Sheet according to status.If status=In stock then copy the row and paste it to...

I am trying to write an if statement to populate 1 of 3 return messages. "Early", "On-Time", or "Late". The Problem is the time passes over more than one day. If we arrive between the planned arrive and planned depart, we are "On-Time". Before the planned arrive, "Early" and after the planned...