+ Reply to Thread
Results 1 to 5 of 5

Help with nested IF function

  1. 11-23-2021, 12:50 PM #1
    pradeepkodali
    pradeepkodali is offline
    Registered User
    Join Date
    08-25-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2007
    Posts
    31

    Help with nested IF function

    Hi,

    Need help in nested IF, I am able to get the desired values in different cells. Wanted to merge both the formulas and get it in single cell. Please help.

    Thanks.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Not able to attach the sample work book.
    Last edited by pradeepkodali; 11-23-2021 at 05:10 PM.
    Reply With QuoteRegister To Reply
  2. 11-23-2021, 12:55 PM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,837

    Re: Help with nested IF function

    You should follow the instructions given in the yellow banner at the top of the screen, in order to attach a sample Excel workbook. Do NOT try to use the Paperclip icon, as it does not work on this forum.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 11-23-2021, 12:58 PM #3
    pradeepkodali
    pradeepkodali is offline
    Registered User
    Join Date
    08-25-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Help with nested IF function

    Thanks, Pete_UK. Attached the sample file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-23-2021, 02:32 PM #4
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,426

    Re: Help with nested IF function

    Select B13 to B18

    ...Sort ranges (RANGE1) smallest to largest

    then

    =INDEX(D13:D18,MATCH(E13,B13:B18,1))
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  5. 11-23-2021, 03:39 PM #5
    pradeepkodali
    pradeepkodali is offline
    Registered User
    Join Date
    08-25-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Help with nested IF function

    Thanks, John for your quick help!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Nested IF Function - if todays date, then return this cell, if false, nested if function
    By fl3tty in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2021, 10:50 PM
  2. Excel function: countifs with nested OR function and wildcards
    By Franfv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-18-2020, 03:57 AM
  3. One nested IF function cell shows incorrect value based on another nested IF function
    By Caruzo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2019, 03:33 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. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  6. COUNTIF/COUNTIFS function + nested user-defined function
    By shamjamali in forum Excel General
    Replies: 1
    Last Post: 05-12-2015, 09:12 PM
  7. Offset function with nested match function not finding host ss.
    By MKunert in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2006, 06:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1