+ Reply to Thread
Results 1 to 7 of 7

If Condition not working

  1. 12-16-2011, 02:25 AM #1
    luckyros
    luckyros is offline
    Registered User
    Join Date
    02-27-2008
    Posts
    65

    If Condition not working

    I am trying to apply if() condition to the data but its not working.

    Wants the TOP 5 products daywise. I have the count but instead of count i want product name to be entered below the mentioned date.

    i am using following formula

    =IF(B5>B6,IF(B5>B7,IF(B5>B8,IF(B5>B9,"Air Cancellation",IF(B6<B5,IF(B6>B7,IF(B6>B8,IF(B6>B9,"Air Flight Enquiry",IF(B7<B5,IF(B7<B6,IF(B7>B8,IF(B7>B9,"Air Booking Status",IF(B8<B5,IF(B8<B6,IF(B8<B7,IF(B8>B9,"Air Refund","Air E-ticket or Invoice"))))))))))))))))

    Please if someone can help me on this.


    I have attached the sample file.
    Attached Files Attached Files
    Last edited by luckyros; 12-16-2011 at 04:24 AM.
    Reply With QuoteRegister To Reply
  2. 12-16-2011, 03:08 AM #2
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: If Condition not working

    There must be an easier way but the attached works
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 12-16-2011, 03:26 AM #3
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: If Condition not working

    I tried using evaluate formula available in the Formulas Sub menu and it didnt allow me. So apparently, you have crossed the maximum number of nested if's that are permitted by excel. How about using VBA for this?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  4. 12-16-2011, 03:58 AM #4
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: If Condition not working

    Arlu, VBA is not necessary. See post #2
    Reply With QuoteRegister To Reply
  5. 12-16-2011, 04:23 AM #5
    luckyros
    luckyros is offline
    Registered User
    Join Date
    02-27-2008
    Posts
    65

    Re: If Condition not working

    Thanks. great job. i was unaware about INDEX MATCH will do the trick..
    Reply With QuoteRegister To Reply
  6. 12-16-2011, 04:52 AM #6
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: If Condition not working

    Yeah me 2.....
    Reply With QuoteRegister To Reply
  7. 12-16-2011, 05:37 AM #7
    huuthang_bd
    huuthang_bd is offline
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: If Condition not working

    Hi everybody
    We have a problem. If quantity of two products are equal, the formula is wrong.
    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)

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