Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need an If statement for Excel that excludes empty cells
I have a column of data (B11:B36) with a Min (B9) and Max (B10). I need an IF
statement that says pass if all data is within the Min/Max and fail if outside the Min/Max but excludes blank cells. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need an If statement for Excel that excludes empty cells
You may need a helper column. For example, use this formula in D11 and copy
down. =IF(B11="","",IF(AND(B11=$B$9,B11<=$B$10),"Pass", "Fail")) Then you can use a formula to see if there are any "Fail"s in column D. =IF(COUNTIF(D11:D36,"Fail")0,"Fail","Pass") Regards, Paul "nascar2000a" wrote in message ... I have a column of data (B11:B36) with a Min (B9) and Max (B10). I need an IF statement that says pass if all data is within the Min/Max and fail if outside the Min/Max but excludes blank cells. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need an If statement for Excel that excludes empty cells
Nascar --
Hows about: =AND(MIN(B11:B36)B9,MAX(B11:B36)<B10) HTH "nascar2000a" wrote: I have a column of data (B11:B36) with a Min (B9) and Max (B10). I need an IF statement that says pass if all data is within the Min/Max and fail if outside the Min/Max but excludes blank cells. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need an If statement for Excel that excludes empty cells
This worked great I just had to add an = to the Min and Max statements.
Thanks "pdberger" wrote: Nascar -- Hows about: =AND(MIN(B11:B36)B9,MAX(B11:B36)<B10) HTH "nascar2000a" wrote: I have a column of data (B11:B36) with a Min (B9) and Max (B10). I need an IF statement that says pass if all data is within the Min/Max and fail if outside the Min/Max but excludes blank cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Save trailing empty cells in a tab delimited text file | Excel Discussion (Misc queries) | |||
eliminating empty cells from chart area | Charts and Charting in Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) |