Results 1 to 3 of 3

Prioritize a condition or overriding other true conditions

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-06-2021
    Location
    Tripoli
    MS-Off Ver
    Still using 2007 in 2023
    Posts
    289

    Red face Prioritize a condition or overriding other true conditions

    Hello everyone, I have a specific requirement for my formula to function correctly.

    I need to prioritize the condition where if L2 equals 96662-100, it should return "96662-100", overriding any other true conditions or nested IF statements.

    Despite placing this condition first, I'm encountering an issue where cell M2 doesn't retain the correct result.

    Could someone help clarify why this might be happening?

    Thanks a lot.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to get first value, when condition true.
    By nnish in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-07-2017, 10:32 AM
  2. Help popup window if condition is TRUE in change event if conditon is true
    By fanku in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-09-2014, 12:46 PM
  3. Change from checking if 2 conditions are true to if any of 4 conditions are true
    By tafoyavision in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 02:17 PM
  4. Replies: 1
    Last Post: 03-26-2014, 02:14 PM
  5. Replies: 3
    Last Post: 02-02-2014, 04:26 AM
  6. open a comment to cell range upon true condition then removing comment on false condition
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 12:55 AM
  7. If either condition is true (3 Or conditions)
    By Helpinghand in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2008, 12:19 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