+ Reply to Thread
Results 1 to 3 of 3

Nested If

  1. #1
    Registered User
    Join Date
    12-25-2020
    Location
    Bangalore
    MS-Off Ver
    2010
    Posts
    1

    Question Nested If

    I get output as per formula and also 0 if false, but in some output i get FALSE, why?

    =IF(SUMIFS($H$51:$H$72,C51:C72,"MidWest")>SUMIF(C51:C72,"North",$H$51:$H$72),IF(C51="MidWest",2*H51,IF(C51="North",1*H51,0)))

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Nested If

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Quang PT

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Nested If

    Looks like your first statement
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    only has an outcome defined when the statement is TRUE, namely
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    . Nothing is defined when the statement is false. XL then reverts to FALSE as an answer.
    Perhaps try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. [SOLVED] Compiling and accessing nested collection within a nested dictionary
    By jrevball in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-06-2020, 10:20 AM
  2. Trying to Convert Excel nested IF to Access nested IIF
    By bbeards in forum Access Tables & Databases
    Replies: 5
    Last Post: 10-10-2018, 10:33 PM
  3. [SOLVED] Nested IF and nested Concatenation formula
    By VisionSmart in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-09-2018, 08:00 AM
  4. [SOLVED] Nested vlookup or nested IFAND function?
    By jeptik in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2017, 02:27 AM
  5. Easier Way To Decipher Nested Nested IF's
    By Vladamir in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2015, 03:37 PM
  6. [SOLVED] Nested Sumif's or how to sum data based on nested criteria
    By dlietz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-07-2014, 11:36 AM
  7. How to reduces Nested IF code(144 Nested IF) to achive same functionality
    By jobseeker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2014, 09:45 AM

Tags for this Thread

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