=if

my formula below is returning #VALUE What I need is: If C2 is "New" and G2 is less than 7 but greater than 3 then return .0.1; If G2 is less than 5 but greater than 3 then return .0125; If G2 is less than 3 but greater than 0 then return .015; if G2 equals zero then return zero. If C2 is...

I have this formula (red) that I have to change manually each month. It is the sum of actuals to date plus projections for the remaining months when the actual is zero (not yet reported). <TABLE style="WIDTH: 728pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=971...

Hi all, I have the following function =IF(B36=VLOOKUP(B36,Sheet2!$A$1:$A$60,1,TRUE),"Yes","X") the function has been copied across a number of cells so that when a correct answer listed in the range on sheet 2 is entered a "Yes" should appear in column C. However this function seems to...

Hi all, Can anyone help a noob out?:confused: I have a list of part numbers in column A in sheet 1 and different vendor pricing in columns C-G. Here is what I have for sheet 2. <table border="0" cellpadding="0" cellspacing="0" width="488"><col style="width: 75pt;" width="100"> <col...

A is full of numbers, in B I want to write =IF(A1=highlighted, A1, 0) and then add up B to have the sum of all highlighted numbers in A - make sense? Is it possible to specify =highlighted?

Hi, I have a large spread sheet with a ton of data on it, sectioned into months. My dilemma is, my supervisors want to see dates when a product was upgraded, but not initally sold. So, for example, we sold something on the 21 of February, but upgraded on March 20th but the way I have it...

I need to LookUp G47 in the 'CONTRACT WORKFORCE'!$E$4:$R$99 and once it finds it a D47 has to match Col 5 on 'CONTRACT WORKFORCE'!$E$4:$R$99. =IF(ISNA(VLOOKUP(G47,'CONTRACT WORKFORCE'!$E$4:$R$99,11,FALSE)),"",VLOOKUP(G47,'CONTRACT WORKFORCE'!$E$4:$R$99,11,FALSE)) I think I should add AND but...

I am trying to work out a formula: If I use the formula: =if(a1=1,"Yes","No") I know if A1 contains 1 the cell will say yes, but if there is anything else it will say no. However I would like to create a formula that would look at A1 and if it contains Text it would copy the text, but if...

Hi Guys, Within the document you will see three blue sections (classes) and then a multitude of other classes that are white. This is the formula within Cell F4 =IF(NOT(ISNA(AA4)),AA4,INDEX(Termone!D$3:E$265, MATCH(D4, Termone!C$3:C$265, 0), MATCH(F$3, F$3:G$3, 0))) There is a shadow...

Hi there, I need some help with an IF formula I'm trying to use to tabulate questionnaire results. I have a "header" row where I have the question, and then below that row are "sub" rows where I placed what the correct response are, yes (cell C3), or no (cell C4). Under that section I have...

So I'm working on a report and I can't seem to find a formula to meet what I want. I have a huge export that contains the following information Column A: Student Name Column B: Entry Date Column C: Type of Entry The only problems I'm having is having Excel search a huge export and put the...

Hi all I've got a spreadsheet which contains, in column L, a field entitled Unique Reference Number (URN). The data is over 9000 rows long. This URN field contains an integer. Each unique integer appears between 1 and X times within the dataset. I'm trying to extract any integers in a...

Hello. I thought this might be interesting. Is there formula to use if I want an IF statement to add a date "TODAY()" to a cell if a corresponding cell is highlighted? I would search for this in the archives if I had a clue what to search for. "Conditional formatting", maybe? In Col J "Appt...

HI, any help would be GREATLY appreciated:biggrin: In Column A1 to 10, I have a series of currency ammounts (for potential sales values); In column B1 to 10, I have a "yes" or "no" text to show whether they are likely to go through or not; I've tried to use the =IF formula to give me a total...