I need help on how to write a formula to compare two columns of results and
return a text field answer.
Column A $32
Column B 65%
Any company listed that is $32 AND 65% will return "Corporate Gold" in
Column C. Thanks!

=IF(AND(A232,B265%),"Corporate Gold","")

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"LisaLisa" wrote in message
...
I need help on how to write a formula to compare two columns of results
and
return a text field answer.
Column A $32
Column B 65%
Any company listed that is $32 AND 65% will return "Corporate Gold" in
Column C. Thanks!