Thread: excel
View Single Post
  #2   Report Post  
Rowan
 
Posts: n/a
Default

Maybe:

=IF(AND(A1="high",B1="low"),"star","dog")

Regards
Rowan

"chefmike" wrote:

the first cell the word "high is Displayed the next cell the word "low" is
displayed and the third cell I need to have the word "star" to display if the
first two are shown. if the first two are different then I need the word
"dog" to be displayed