Results 1 to 9 of 9

IF formula with 4 conditions...

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2023
    Location
    UK
    MS-Off Ver
    2019
    Posts
    3

    IF formula with 4 conditions...

    Hi all. Currently trying to wrestle IF formulas.

    Here is a screenshot of my sheet:

    The formula will go in column K. The top three rows are real data, but the bottom line that I have selected (which is row 9) is 'dummy' data that I'm using to check the formula works.

    SShot.png

    What I'm trying to achieve:
    If I9 is blank, show nothing (i.e. blank cell)
    If J9 is blank, show nothing (like above)
    If J9 is between H9 and I9, show "true"
    IF J9 is after I9, show "False"

    The final complication is that if *today's date* is after I9, then K9 should show false, even if I9 is blank.

    (I've used conditional formatting in column K to show a background and font colour of green if the cell says true, and red if it says false, hence why you can't actually see any text in those cells).

    I'm not sure if what I want is even possible, but any help or advice would be greatly appreciated!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula with multiple conditions, if met then apply various percentage formula
    By JenniferGibbons1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-14-2021, 09:24 AM
  2. [SOLVED] Help for IF conditions with multiple Conditions (scenario more than 5 conditions)
    By meily_o26 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-16-2019, 02:13 AM
  3. Assistance with CountIF formula and additional formula conditions
    By solios in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-18-2016, 01:46 PM
  4. Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  5. [SOLVED] How to add 2 conditions to a Formula or modify existing formula
    By Frank121977 in forum Excel General
    Replies: 9
    Last Post: 12-22-2012, 03:13 PM
  6. Formula With Many Conditions
    By scubasteveku in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2012, 12:49 PM
  7. one formula,3 conditions
    By arcadian in forum Excel General
    Replies: 3
    Last Post: 06-30-2008, 09:27 AM

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