+ Reply to Thread
Results 1 to 2 of 2

help with forumla needed... getting a yes/no answer to ??

  1. #1
    Registered User
    Join Date
    05-29-2005
    Posts
    1

    Talking help with forumla needed... getting a yes/no answer to ??

    Im trying to create a formula in Excel but im having some problems. Im not even sure that it can be done!
    Basically the cell that the formula is in must return a "yes" or "no".

    I want the formula to reference three seperate cells in that row. Basically it should return a "yes" if the first cell has a value greater to or equal to 10000, the second cell is greater or equal to 4 and the third cell has a value of 1. Basically if it does match this criteria it should return with a "No".

    Any help on creating this would be very apprciated TIA!

  2. #2
    Max
    Guest

    Re: help with forumla needed... getting a yes/no answer to ??

    One way ..
    Assuming the 3 cells are A1, B1 & C1,
    Put in say, D1: =IF(AND(A1>=10000,B1>=4,C1=1),"No","Yes")
    Copy D1 down to return likewise for the other values in cols A to C
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1 22' N 103 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "shorn" <shorn.1pscyb_1117357508.2388@excelforum-nospam.com> wrote in
    message news:shorn.1pscyb_1117357508.2388@excelforum-nospam.com...
    >
    > Im trying to create a formula in Excel but im having some problems. Im
    > not even sure that it can be done!
    > Basically the cell that the formula is in must return a "yes" or "no".
    >
    >
    > I want the formula to reference three seperate cells in that row.
    > Basically it should return a "yes" if the first cell has a value
    > greater to or equal to 10000, the second cell is greater or equal to 4
    > and the third cell has a value of 1. Basically if it does match this
    > criteria it should return with a "No".
    >
    > Any help on creating this would be very apprciated TIA!
    >
    >
    > --
    > shorn
    > ------------------------------------------------------------------------
    > shorn's Profile:

    http://www.excelforum.com/member.php...o&userid=23835
    > View this thread: http://www.excelforum.com/showthread...hreadid=374881
    >




+ 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