close
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 gt;$32 AND gt;65% will return quot;Corporate Goldquot; in
Column C. Thanks!
=IF(AND(A2gt;32,B2gt;65%),quot;Corporate Goldquot;,quot;quot;)
and copy down
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;LisaLisaquot; gt; wrote in message
...
gt; I need help on how to write a formula to compare two columns of results
and
gt; return a text field answer.
gt; Column A $32
gt; Column B 65%
gt; Any company listed that is gt;$32 AND gt;65% will return quot;Corporate Goldquot; in
gt; Column C. Thanks!
gt;
gt;
gt;
全站熱搜
留言列表
