if error

Hi All, Below is the data: I am trying formula, but giving error...

<tbody> MDT Date Next MDT Was MDT Met? Days Over Due 03/31/17 06/30/17 N 02/28/17 05/10/17 Y </tbody> First formula or conditional formatting is to create a formula that will turn the entire row red if the following conditions exist: 1. Column C is a "N" 2. Column B is past today's...

Hello all, I do not know where my mind is playing tricks. Mind or math, not sure. This is the formula that i used to average (with blue color) all the rows and all the columns in the data set (with black collor): =IFERROR(AVERAGEIF(K55:P55,"<>0",K55:P55),"") But in the same data, if i...

Help! What is wrong here? Why isn't it working? =IF((i7)<=10,"Low 10%", =IF(( i7) <=30 and >10,"Low Mid 11-30%",= IF((i7) <=60 and >30 , " Mid Range 31-60%",=if((i7) <=80 and >60,"High Mid 61-80%",=if((i7) <=100 and >80 ,"High 81-100%","error")) :(

I am having issues with a complicated formula that has previously worked. In the past this formula insert text in 70-100 cells. Now I am only yielding text in about 15 cells. The goal of the formula is to copy the text from cell CO3 into cell CP2, if cell E3 = "system" and the text in CO3 is...

I have 4 columns (A: Cat#,B: Member#,C: Vendor#, D: Price) on Sheet1. Columns A thru C on Sheet 1 has a different number in Rows 2 thru 10 and Column D is blank to enter the VLookup formula. On Sheet 2 I have 2 Columns (A: Cat#, B: Price). Column A: has several rows with numbers and Column B...

I would like the macro to loop through 1 to 100 using the value for i as the row value for the range. Then the macro should search for all cells which match the value in "Ai" and delete the rows. Once this is done (and the find function errors) the value for i should increment by 1 and do it...

Hey guys the two formulas below are returning 0 if there is not a value. I have used this formula with median(if()) and average(if()) and it works. Any help will be greatly appreciated. =IFERROR(COUNT(IF('Both MLS RS'!$BE$33:$BE$10000>='Zipcode Analysis'!$N2,IF('Both MLS...

Folks: I want to add this functionality to my code: VBA file browser command to open any workbook to define as SourceWB What is the easy way to add this functionality to the following code (Or the most efficient way to do what this code does and add this functionality to it)?: Sub...