Closed Thread
Results 1 to 4 of 4

2 formulas in one cell issue

  1. #1
    Registered User
    Join Date
    11-13-2012
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2010
    Posts
    21

    2 formulas in one cell issue

    Hi
    On the attached document, Im having trouble with the formula in cells C5-I5. Essentially, I want it to display text (in this case ASAP U R G E N T) in the cells if the day chosen via the calendar in B5 is less than 60 days from today, if it is greater than 60 days I want it to post a day/date/month. My formulas for both seem to be correct, but the spreadsheet isn't choosing one of the other based on what is chosen in B5.

    Here is an example of my formula in C5

    =IF(B5<TODAY()-60,"ASAP",IF((B5-150+150)=0,"",B5-150))

    I'm using the 150 to denote days after the date inputted in B5 to calculate a date (which is working well).

    Any ideas?

    I've attached the spreadsheet as well.

  2. #2
    Forum Contributor
    Join Date
    11-05-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: 2 formulas in one cell issue

    OK, two observations...
    First, to answer your problem, you are getting an error because Excel is not treating the value in B5 as a date. The most likely cause is that you are entering the date in the mm/dd/yyyy format, and your system is set up for dd/mm/yyyy format.
    Second, I noticed that in your formula for C5, you are using B5-150+150. Isn't B5-150+150=B5?

    Don't forget to click the little star to the left of this screen if you feel I helped!
    Taming the Excel dragon... www.TheExcelphile.com

  3. #3
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: 2 formulas in one cell issue

    B5 is text...

    Change all references of B5 to datevalue(B5)...

  4. #4
    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,929

    Re: 2 formulas in one cell issue

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-form...a-formula.html

    Thread Closed.
    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

Closed Thread

Thread Information

Users Browsing this Thread

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

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