Return Value using If statement or Lookup?
I have column a1 thru a100 are pass/fail values, column b1 will return a
"fail" if any of the rows in column a1:a100 has a "fail" value. Do you have a if statement I can use? |
Return Value using If statement or Lookup?
=IF(Countif(A1:A100,"Fail")0,"Fail","") -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109898 |
Return Value using If statement or Lookup?
Your use of the phrase "pass/fail values", coupled with the fact you want to
report the word "fail" in another column, suggests to me there are numerical values in Column A and that there is a certain value marking the point at which an item is considered failed. However, you didn't tell us what value marks a failure nor whether numbers higher or lower than it constitute a failed item. Also, your use of the term "column b1" is confusing as b1 is a cell, not a column. Given your omissions, I will make some assumptions and then give you a formula for those assumption (you will have to modify it to fit your actual conditions). Assuming 123 is the value marking where failures occur and that numbers equal to or higher than this value are considered as failed, and that you want the word "fail" in Column B next to each failed value, then give this formula a try (put it in B1 and copy it down)... =IF(A1=123,"Fail","") -- Rick (MVP - Excel) "Malva" wrote in message ... I have column a1 thru a100 are pass/fail values, column b1 will return a "fail" if any of the rows in column a1:a100 has a "fail" value. Do you have a if statement I can use? |
All times are GMT +1. The time now is 02:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com