+ Reply to Thread
Results 1 to 2 of 2

AND/IF Formula help

  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    N.Ireland
    MS-Off Ver
    Excel 2003
    Posts
    76

    AND/IF Formula help

    I have written a formula with an AND logical function but i need to add an extra IF function into the formula as shown below:

    Please Login or Register  to view this content.
    I want to add in IF THE value in AX99 not equal to 2-3 output "N/A".

    Can anyone help?
    Last edited by PRodgers; 08-27-2009 at 05:59 AM.

  2. #2
    Registered User
    Join Date
    06-03-2009
    Location
    N.Ireland
    MS-Off Ver
    Excel 2003
    Posts
    76

    Re: AND/IF Formula help

    I have sorted this:

    =IF(AX3<>"2-3", "NA",AND(P3="Yes",T3="Yes",AD3="Yes",AM3="Yes",BC3="Yes",BE3="Yes",BG3="Yes",AX3="2-3")

+ 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