Return 3 values

[TimBrowne]

Hello,

Having difficulties to get my furmula working, I have the following:

=IF((U5<L3; "PASS";IF(U5=0;"";IF(U5<1;"";"FAIL")) )

If U5 is higher than the valua in L3 it needs to return "PASS", if it is 0 it needs to remain Blanc, if the value is anywehere between 1 and 10 it needs to return "FAIL"

Hope you can help me.

Thank you!

[JohnTopley]

Try

=IF(U5>L3; "PASS";IF(U5=0;"";IF(AND(U5>=1;U5<=10);"FAIL";"")) )

[TimBrowne]

Thank you, still struggling. Working on the workbook for too long I guess... Maybe it's easier if I upload it and explain what I want to do, attached the file.

1. Column U Shows the count of "GK" and "NVD" that are entered for columns K to T. If the value of the sum of these 2 counts is 1 or more the value in column V needs to return FAIL.
2. If all values in the columns K to T are VD it should recognize this and show pass in Column V
3. If there are no values the cell needs to remain empty (also if not all columns are filled in)

Small detail. this template now has 10 columns to enter data, however this can be less too, the amount of columns (and values column V and U need to look at) is mentioned in L3 (used in other formula's). The number of columns not needed will be deleted from the template)

[samba_ravi]

feed some data in the attached file and show the expected result manually for better understanding.

[JohnTopley]

Try

=IF(COUNTIF($K5:$T5,"VD")=L3; "PASS";IF($U5>=1;"FAIL",""))

[TimBrowne]

That's doing exactly what I needed, thank you so much!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.