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!
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(A2>32,B2>65%),"Corporate Gold","")
and copy down
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"LisaLisa" <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks