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
|