If question

**david_pt** · 12-19-2009, 12:14 PM

So I got data organised in a table, from A to H.

A3:G10 is normal data...
In H3:H10 it shows blank or an *.

1) In collumn J, I want to specify if in those H3:H10 it finds any *. If it finds any, a word like "incompatible" will appear; if not, "compatible" will appear.
2) Furthermore, let's say I want not only the condition imposed in 1), but also I ask it to look at a value in a cell and see if it's superior to 10. IF both are met, it shows "compatible", if one fails, "imcompatible".

I guess it's a simple question but I couldn't figure it out.
Thanks

**JBeaucaire** · 12-19-2009, 01:38 PM

Hi David. Put together a sample workbook showing examples of the data you want evaluated. Be sure we see examples of "incompatible" and "compatible" as well as this cell you want evaluated for ">10". Mock up your desired results manually so we can see, and make sure it's crystal clear why each example has the result it does.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

**david_pt** · 12-19-2009, 03:32 PM

Ok I'll send this attachment.
It's not my working excel file but everything is just the same.

Everything you need to know is on sheet number 2, so if you find any problem tell me.

Thanks

**JBeaucaire** · 12-19-2009, 04:28 PM

This formula will tell you which L1, L2 or L3 your set of names qualify for:

=IF($B$5<5936, IF(COUNTIF($C$2:$C$4, "~*")=0, "L3", "L1"), "L2")

**david_pt** · 12-19-2009, 05:31 PM

Huge final edit of the message: It had an error but I figured it out now. I'm not sure if this is what I'm looking for anyway, I'll come back with "more" if it still doesn't suit it.