Hi again all
Some time ago you helped me with a formula
=IF((H223="L")+(N223="L")+(T223="L")=1,"L",IF((H223="L")+(N223="L")+(T223="L")>1,"LL",""))
This tests 3 cells, in H, N, and T for "L" and returns L or LL or null, depending on how many there are.
It works nicely and thanks for the help.
I now need to extend this to test for "X" as well, (returning L as before). I could simply extend the IF with an OR statement, or I could use the Find function to check for either L or X in each cell. I know how to do this, but either will give me a messy function.
Before I start, does anyone see a more elegant way of doing it ?
Hope this is clear? Thanks, KK
Bookmarks