+ Reply to Thread
Results 1 to 4 of 4

Formula Help - nested statements - different things if cell blank or cell part of formula

  1. #1
    Registered User
    Join Date
    07-14-2016
    Location
    Dallas, TX
    MS-Off Ver
    2013
    Posts
    2

    Formula Help - nested statements - different things if cell blank or cell part of formula

    Term Date Return Date Comp. Level
    7/10/16 7/13/16 higher
    3/5/16 7/14/16 lower
    4/7/16 7/14/16 lower
    7/3/16 7/8/16 higher
    1/9/15 7/15/16 lower

    I am trying to create a formula that will fill in the Comp Level column based on the following criteria

    If return date is blank then Comp. Level is blank
    If return date minus term date is less than or equal to 14 then Comp. Level is higher
    If return date minus term date is greater than 14 then Comp. Level is lower.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,737

    Re: Formula Help - nested statements - different things if cell blank or cell part of form

    try

    =IF(B2="","",IF( B2-A2<=14, "higher","lower"))
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    07-14-2016
    Location
    Dallas, TX
    MS-Off Ver
    2013
    Posts
    2

    Re: Formula Help - nested statements - different things if cell blank or cell part of form

    Thanks - that is exactly what I needed

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,737

    Re: Formula Help - nested statements - different things if cell blank or cell part of form

    you are welcome

+ 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. Nested IF Statements for Blank Cell
    By missyboox22 in forum Excel General
    Replies: 3
    Last Post: 01-07-2015, 01:01 PM
  2. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  3. Replies: 4
    Last Post: 11-05-2012, 07:56 PM
  4. Replies: 12
    Last Post: 05-15-2009, 08:38 AM
  5. if cell blank keep part of the formula How to do it?
    By Dipwind in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-27-2006, 05:29 AM
  6. Replies: 1
    Last Post: 07-20-2006, 03:05 PM
  7. [SOLVED] Sum in first blank cell and a few more things...
    By Bleu_808 in forum Excel General
    Replies: 3
    Last Post: 05-04-2006, 07:10 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