+ Reply to Thread
Results 1 to 2 of 2

Problem regarding IF Function.

  1. #1
    Registered User
    Join Date
    11-28-2014
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2010
    Posts
    1

    Problem regarding IF Function.

    Dear concern,

    Would you please make me understand the below formula in a better way.

    =IF(C2>=11000,IF(C2*50%<=6200,6200,C2*50%),IF(C2*60%<=3400,3400,C2*60%))

    Regards
    Shakil

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,901

    Re: Problem regarding IF Function.

    Hi, welcome to the forum

    You have a series of nested IF()'s there

    =IF(C2>=11000,IF(C2*50%<=6200,6200,C2*50%),IF(C2*60%<=3400,3400,C2*60%))
    The 1st part is to test if C2>=11000, which will produce a TRUE or FALSE result

    if TRUE, do the 1st of the next 2 IF()'s...
    IF(C2*50%<=6200,6200,C2*50%)
    This 1st tests to see if half of C2*50% <= 6200, if it is, it uses 6200, otherwise it used half of C2

    If C2 < 11000, it does the last IF()...
    This 1st tests to see if C2*60%<=3400, if it is, it uses 3400 otherwise it uses C2*60%

    This could also have been shortened to this...
    =IF(C2>=11000,MAX(6200,C2*50%),MAX(3400,C2*60%))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 6
    Last Post: 10-20-2013, 07:16 PM
  2. MID function problem
    By alfgrey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-11-2013, 06:50 AM
  3. Problem Inserting Round function into an IF function
    By Ash87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 05:37 PM
  4. Problem with Sum function
    By kumawat_s in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-17-2007, 05:18 PM
  5. FV Function Problem
    By Andy Wiggins in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 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