ifstatement

Hi. I am trying to automate a process that can be laborous. So let's say on cell C2:C10, I used vlookup from a data file to pull out a % which ranges from (0%-5%). On the corresponding column D, I would like to have a rating, which is taken out from a rating scale. So my congested IF statement...

column B & column C are variables column E & column F are constants (2.5 & -2.5 respectively) Output column is column H. Please bear with my language...please I am using H2<f2,-100,0)) and="" able="" to="" get="" correct="" answer. =IF(B2>E2,100,IF(C2 is less than F2,-100,0)) <f2,-100,0))...

In SO2=IF(RN2=FALSE,0,MAX(SK2,SL2,AX2)) But I want the formula to check... If RV2=100, then also MAX(SK2,SL2,AX2) else 0 How to accomplish

Please I really need help! I am definitely a beginning excel user, and after using google and looking through this forum I am still unable to figure this out. Answers will be much appreciated! Basically I have data that specifies how much of each item (codes) are used per phase. For example...

I think I need to combine a Vlookup and IF statement together. Basically, I have a list of participants with a medication start date and I also have a list of medical reports for each of those participants (note: each participant has more than 1 medical report). Essentially, I would like to pull...

Hi, I would really appreciate it if someone could help me please. I've written an IF statement where I want the values to return true if all selected cells equal to zero and false if equal to anything else. The values are rounded to 2 decimal places. However, from 7 decimal places onwards it...

Hi, I have this data Sheet 2 <tbody> Name Date Working Hours Task Status AND SO ON... Sam 01/01/2015 9.00 Help Pat OK Sam 01/02/2015 9.00 Cook OK Sam 01/03/2015 9.00 Walking PENDING Sam 01/04/2015 9.00 Watch TV OK PAT 01/01/2015 2.00 Study OK PAT 01/02/2015 2.00 Clean OK...

Hello, First post, heard a lot of great things about this forum. I have a tricky situation. I'm trying to give a prorated revenue total by month for incremental postings of revenue (ex:1/11/14-1/17/14=$76,595). Obviously the amounts like the one in my example are simple, but I'm having trouble...

Hi All, I am having a lot of trouble with a particular spreadsheet I'm trying to develop. It's a project tracking tool and what I need to do is copy and past all the late projects into a specific sheet for review with our dept heads which is quite laborious. I am trying to find someway to copy...

Hello, I am trying to Nest an Vlookup within and IF statement to return a "YES" if the value is in another table. I would also like it to return "NO" if the value is not in the table. With the formula I have now it will pull the "YES" if the value is in the table but it will not pull the "NO"...

Hello, I want to pull a value from one table into another, but it cannot be a value that is listed in a specific list (which continually grows). I have a blank table which I want to automatically populate with a value from a database that is sorted in descending order. The formula needs to pull...

I'm using the formula below to populate a cell if another cell does not contain any of the following "R", "0" or is Blank. if the cell "sheet2!G11" has any of those in it the formula cell is left Blank. If the cell contains anything else then it populates with what is in cell "sheet2!D11"...

Hey everyone, I am having troubling articulating what I would like to do. I have a series of numbers that are all different but I would like to add the same things to all of them. Here is the example:the original well name is 00/06-02-072-21W4/0 I would like a formula that would add a 1 to the...

Hi all, I have an IF statement where I want code in a different macro executed when a cell is populated with a specific value. My code thus far is below: Sub RUNOPT() Sheets("Main Page").Select If Sheets("Main PAGE").Range("L15") = "A" Then Call RUNA If Sheets("Main PAGE").Range("L15") = "B"...

Hello, Currently I have a dropbox that allows the user to choose: Hong Kong London Berlin I have an If statement that determines what address to display dependent upon the city chosen from the dropbox. My issue is that the formula seems to work but requires me to actually click into the...

Hey everyone. here is the situation I am dealing with. I have well data that starts at different times arranged by month over several years Jan 12 Feb 12 Mar 12 Apr 12 May 12 June 12 July 12 August 12 Sept 12 Oct 12 Dec 12 Jan 13 Feb 13 ETC Well A...

I need help creating a VBA IF statement. For example this could be used for a budget, a forecast etc. If the value in cell K17 = "F00" of Sheet1 then clear the values (not formats) of the cells in the Named Range "OneElevenSalary" of Sheet2. If the value in cell K17 = "F01" of Sheet1 then...

Hello, I'm trying to determine from a large set of data, new records that have entered a data set over the course of a quarter. I have one column with dates. All of the dates in this column are either 9/30/2013 or 6/30/2013. The next column includes an ID number. If an ID number is showing...

I am trying to write a nested if statement that if column W = "Correct" and column AA is empty then the blanks will colour in. I have tried a number of different ways and I'm hoping I'm getting close with the coding below. I am doing several checks on my worksheet that's why I need this to be in...

Hello all I am using Excel 2003 and I have a problem that I believe will be solved with an IF function, I'm just not entirely sure how to apply it! I have enclosed an example table Basically, I need to count any row that has a x in any column between B and H. For example row 2 contains 3 x's...