Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Functions and Formulas » conditional formula problem

conditional formula problem

Previous | Next
Latest post Thu, Apr 3 2008 11:01 AM by Nick Hodge. 1 replies.

  • Thu, Apr 3 2008 9:48 AM

    • rogerw
    • Top 500 Contributor
    • Joined on Thu, Apr 3 2008
    • Posts 1
    • Points 21

    conditional formula problem

    Reply |Contact

    This is probably so basic to most of you that you will laugh but here's what I'm trying to do and I just can't seem to make it work.  Column C of my spreadsheet is for categroies of work and contains values  from "A" thru "G".  I want to create a formula that says if column C is anything other than category "B" and column M contains "YES" then  a "YES" should also be inserted in column N.  Can anyone help?
    • Post Points: 21

  • Thu, Apr 3 2008 11:01 AM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 304
    • Points 5,058
    • MVP

    Re: conditional formula problem

    Reply |Contact |Mark as Not Answer

    Roger

    Use an AND function

    =IF(AND(C1<>"B",M1="YES"),"YES","")

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    Filed under:
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.