+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    LisaLisa
    Guest

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

    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!




  2. #2
    Bob Phillips
    Guest

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

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




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1