+ Reply to Thread
Results 1 to 2 of 2

IF formula with different returns depending on date

  1. #1
    Registered User
    Join Date
    08-16-2014
    Location
    dublin
    MS-Off Ver
    2010
    Posts
    24

    Talking IF formula with different returns depending on date

    Hello Everyone,

    I want to know if the date in B is either =,<, or > than the date in C and have the return below on column D.

    = Not negotiated
    > Negotiated Up
    < Negotiated Down

    I really appreciate your help.

    ben
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: IF formula with different returns depending on date

    Without looking at your file....

    =if(B1>C1,"Neg Up",if(B1<C1,"Neg Down","Not Neg"))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 7
    Last Post: 07-14-2017, 12:04 PM
  2. If formula, multiple returns depending on value
    By benjamin_1986 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2017, 03:19 AM
  3. Date Formula returns #DIV/0
    By rtshort in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 06-04-2016, 10:15 PM
  4. [SOLVED] I need a formula that will allow me to Select a date and add all returns after that date
    By yomamma34 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2016, 09:27 AM
  5. Help with formula that returns a Date Code from a Date
    By mike7952 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-11-2015, 01:28 AM
  6. [SOLVED] I need a formula that looks at a day and a date range and returns the date corresponding
    By john dalton in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-27-2014, 05:38 AM
  7. [SOLVED] Formula that returns the date of every Friday of the month
    By MROMAR in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2012, 03:00 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