+ Reply to Thread
Results 1 to 3 of 3

More than the limit (Excel XP)

  1. #1
    Registered User
    Join Date
    11-22-2012
    Location
    Laguna, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    44

    More than the limit (Excel XP)

    IF(A3<=30,"NC",IF(AND(C3="SEC",,AND(A3>30,A3<=180)),"SS1",IF(AND(C3="SEC",AND(A3>180,A3<=365)),"SS2",IF(AND(C3<>"SEC",AND(A3>30,A3<=90)),"SU1",IF(AND(C3<>"SEC",AND(A3>90,A3<=120)),"SU2",IF(AND(A3>365,A3<=1825),"Ds",IF(AND(A3>120,A3<=180),"Du",IF(A3>1825,"Ls","Lu"))))))))

    Questions and Requirements:
    Automatic = will calculate automatically by using the formula
    Manual = will input the chosen class, and the amount will calculate automatically.
    I am using Excel XP, the formula developed was exactly as it is for the "IF STATEMENT FUNCTIONS", more than the limit will no longer calculate. What are or any alternative functions to be used?
    LAST CONDITION: IF(ManualClass="","",FALSE
    (I AM LOOKING FOR THIS LAST CRITERIA)

    PLEASE HELP ME COMPUTE AND FIND THE LAST CONDITION PERFECTLY OK... THANK YOU.
    Marj
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: More than the limit (Excel XP)

    SEE THE ATTACHED FILE
    Some changes made to your criteria
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    11-22-2012
    Location
    Laguna, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    44

    Re: More than the limit (Excel XP)

    Thank you very much!

    Hope to ask you again...

    (I can't see the star you mentioned nor the "solved" button)

+ 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] find the lower and upper limit if data is in between on that limit
    By clangeles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2012, 06:18 AM
  2. Bypass Excel Rows limit and continue to copy data files to Excel
    By Mach7 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-16-2012, 07:40 AM
  3. Replies: 1
    Last Post: 01-13-2011, 02:29 PM
  4. Row limit in Excel
    By mannan in forum Excel General
    Replies: 3
    Last Post: 04-26-2006, 07:40 AM
  5. [SOLVED] Row limit in Excel
    By Jon Chase in forum Excel General
    Replies: 5
    Last Post: 03-29-2005, 08:12 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1