+ Reply to Thread
Results 1 to 3 of 3

If function with AND imbedded

  1. #1
    Registered User
    Join Date
    05-16-2021
    Location
    Canada
    MS-Off Ver
    365
    Posts
    1

    If function with AND imbedded

    Here is the worksheet

    I know how to use the IF function, but I need to include an AND ....conditions.
    In this worksheet:
    if a>b then it returns DOWN
    if a<b then it returns UP
    if a=b then it returs NEUTRAL

    but I need to add another condition:
    if a+b=6 then it shoud return MAX Score
    Attached Files Attached Files
    Last edited by Claude2; 05-17-2021 at 09:39 AM. Reason: Including worksheet

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,421

    Re: If function with AND imbedded

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: If function with AND imbedded

    Claude, welcome to the forum and thanks for the file.

    However, nowhere do you show where your problem is, nor what you are trying to do. You have a number of sheets in that find, you should not expect members to hunt through your file to try and guess what you need.

    Explain - in detail what you are trying to do, where you are trying to do it, where you expect your output and what you expect that output to look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. HYPERLINK function with imbedded TEXT function possible?
    By rob5299 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-28-2015, 05:20 PM
  2. Imbedded if then?? HELP
    By Freer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-14-2013, 09:58 AM
  3. If function with another imbedded if function
    By ksmith2001 in forum Excel General
    Replies: 3
    Last Post: 10-27-2010, 10:46 PM
  4. Conditional Sum (with several imbedded)
    By Liquifiber in forum Excel General
    Replies: 4
    Last Post: 02-02-2009, 03:06 PM
  5. how to over come limit of 7 imbedded if's
    By wejofost in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2007, 12:05 PM
  6. Replies: 1
    Last Post: 12-02-2005, 09:35 AM
  7. imbedded if statements
    By ksusong in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 07:05 PM

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