Text in cell range

[jasonbrooks]

Hi,

I am hoping someone can help with what I suspect is a simple requirement...

Cells C3 through to C6 contains the words "one", "two" and/or "three".

If any cells between C3 and C6 contains the text "one", I need cell C2 to display "Good".

If all cells between C3 and C6 contains the text "two", I need cell C2 to display "Bad".

If all cells between C3 and C6 contains the text "three", I need cell C2 to display "Ugly".

If the cells between C3 and C6 contains the text "two" and "three", I need cell C2 to display "Bad".

I hope someone can help.....it would really make my day......

 

[tweedle]

Hi,
Give this a swing:
=IF(COUNTIF(C3:C6,"One")>0,"Good",
IF(COUNTIF(C3:C6,"Three")=4,"Ugly",
IF(AND(COUNTIF(C3:C6,"Three")>0,COUNTIF(C3:C6,"Two")>0),"Bad",
IF(COUNTIF(C3:C6,"Two")=4,"Bad","unspecified"))))

 

[jasonbrooks]

You are the man for sure! Thank you!

I wish I could give you a Fist Full of Dollars.......



.....sorry, I couldn't resist!

Thanks again!!!

 

[tweedle]

Welcome to The Board.

For a Few Dollars More you can get Two Mules for Sister Sarah and go to Tombstone where, save three known as The Outlaw Josey Wales, Pale Rider, and a man known only as [The] High Plains Drifter, they are all Unforgiven and known to Hang 'Em High.

it was an impulse...