Excel formula: how to write >$32 AND >65% = "Corporate Gold"

L

LisaLisa

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!
 
B

Bob Phillips

=IF(AND(A2>32,B2>65%),"Corporate Gold","")

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top