Formula

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

I have a range of cells in a column that contains numbers in each cell
(i.e. 50,55,58,52,51,etc...). I want to create a formula that will look
at this range and if the number is less than 52 "fail" if not "pass".
 
Brent,

Say your list was in A1:A100
In B1:
=IF(A1<52, "Fail", "Pass")
copy down through B100

Note, this formula will not handle stuff like no scores, or text
ie "Did not write" it will return a pass for values such as these.
If you would prefer a fail for values like these.

=IF(A1>=52, "Pass", "Fail")

Dan E
 
Sorry 'bout that Brent, misinterpreted.

=IF(COUNT(A1:A100)>COUNTIF(A1:A100,">=52"), "Fail", "Pass")

of course you'll need to adjust this to fit your range.

Counts the number of cells, and counts the number >= 52
If the total # is larger than the # greater than 52 returns
fail, otherwise it returns pass.

Dan E
 
Dan, Still not what I'm looking for. If I had, in a column
52,52,53,55,58,56,52,54 I need a formula that will look at this range
and return a "pass" because there are no cells less than 52. If I had,
in a column 52,51,53,55,58,56,52,54 I need the formula to look at this
range and return a "fail" because there is one cell that is less than
52.

Thanks for the help
 
Works for me although it could also be written

=IF(COUNTIF(A1:A10,"<52"),"fail","pass")
 
Back
Top