+ Reply to Thread
Results 1 to 3 of 3

Nesting multiple If & AND formulas

  1. #1
    Registered User
    Join Date
    04-14-2014
    Location
    Lake Wales, Florida
    MS-Off Ver
    Excel 2016 (365)
    Posts
    10

    Post Nesting multiple If & AND formulas

    I am attempting to apply the following two formulas to a single (range) cell. Any assistance in applying the proper syntax would be greatly appreciated. Each works independently, but I really need them to work together. Help.......please.....
    Thank You.

    =IF(AND($G11+$K11>0,$R11=$S$14),"ERROR",IF(AND($G11+$K11>0,$R11=W$9),$G11*$U$17,"-"))

    =IF(AND($R11<>$S$14,$G11+$K11=0),"ERROR","_")

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Nesting multiple If & AND formulas

    Try

    =IF(OR(AND($G11+$K11>0,$R11=$S$14),AND($R11<>$S$14,$G11+$K11=0)),"ERROR",IF(AND($G11+$K11>0,$R11=W$9),$G11*$U$17,"-"))

  3. #3
    Forum Contributor
    Join Date
    01-07-2013
    Location
    south africa
    MS-Off Ver
    Excel 2003-13
    Posts
    210

    Re: Nesting multiple If & AND formulas

    Hello
    I know my vision is not 100% anymore but is that a minus results in the 1st formula and an underscore result in your 2nd formula ?

    Regards
    Most helpful to mark solved items as such (see help for directions). Star ratings are always welcome.

+ 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. Need help nesting some formulas
    By jceg316 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2014, 12:28 PM
  2. Nesting If formulas
    By lmennucci in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2013, 04:12 PM
  3. [SOLVED] Nesting multiple IF formulas
    By tiffany04530 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-14-2012, 01:32 PM
  4. [SOLVED] Nesting Formulas
    By colbyjack in forum Excel General
    Replies: 10
    Last Post: 05-31-2012, 05:23 PM
  5. nesting multiple formulas involving cell properties
    By jrtaylor in forum Excel General
    Replies: 5
    Last Post: 03-05-2011, 11:37 AM

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