+ Reply to Thread
Results 1 to 9 of 9

IF formula with 4 conditions...

  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

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: IF formula with 4 conditions...

    Please try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by HansDouwe; 08-16-2023 at 05:33 PM.

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

    Re: IF formula with 4 conditions...

    Thanks for trying, but this doesn't offer the true or false solutions I need

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,664

    Re: IF formula with 4 conditions...

    Try this
    Please Login or Register  to view this content.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: IF formula with 4 conditions...

    Thanks Willem for correcting my formula. .

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

    Re: IF formula with 4 conditions...

    I've got part of what I want to do with:
    =IF(I9>=(TODAY()),"",IF(J9<I9,"true","False"))
    But the problem is, it doesn't show true or false when I enter dates in column J. For example, this should be true (colour green) in column K:
    Attachment 839944

    and this should be false (colour red) in column K:
    Attachment 839945

    But as you can see, neither of them is.

    Anyone have any ideas?

  7. #7
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: IF formula with 4 conditions...

    If I click on the links of your attachments, I get the message "Invalid attachment specified".

    Please upload your sample sheets via "Go Advanced" and "manage attachments".
    See yellow banner at the top of this page.

  8. #8
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: IF formula with 4 conditions...

    it doesn't show true or false when I enter dates in column J
    I guess it doesn't show true or false, because I9>=TODAY().
    You code =IF(I9>=(TODAY()),"",IF(J9<I9,"true","False")). In that case the value of J9 does not matter, if I9>= TODAY(). In that case your formula returns always "".

    Did you try the formula of Willem in Post #4?
    Last edited by HansDouwe; 08-17-2023 at 04:47 PM.

  9. #9
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: IF formula with 4 conditions...

    deleted dupilcated post
    Last edited by HansDouwe; 08-17-2023 at 04:48 PM.

+ 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] 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