Results 1 to 2 of 2

Formula Problem Days360

Threaded View

  1. #1
    Registered User
    Join Date
    01-09-2012
    Location
    Miami, Florida
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    1

    Formula Problem Days360

    Greetings all. Hoping you can help with anissue that just cropped up.

    Days360 calculation between cells in different column/rows. Calculation returned a 1 or 0 based on value of the Days360 calculation.
    Format:
    =IF(DAYS360(E11,D12)<=7,1,0)
    =IF(AND(DAYS360(E11,D12)>=8,DAYS360(E11,D12)<=30),1,0)
    =IF(AND(DAYS360(E11,D12)>=31,DAYS360(E11,D12)<=60),1,0)
    =IF(AND(DAYS360(E11,D12)>=61,DAYS360(E11,D12)<=90),1,0)
    =IF(DAYS360(E11,D12)>=91,1,0)

    Each of these 'IF' statements populates each column across a row and each row has the same formula.
    I used to get a 0 value if the calculation did not fall directly into the cell range but now I am getting '1' values spanning across the columns. I believe it has something to do with the 1st portion of the calculation.

    See the attachment for an example. I need to get back to just 0 & 1 across the coloumns instead of 0,1,1,0.
    Thanks in advance.
    Attached Files Attached Files
    Last edited by Robertj; 01-09-2012 at 04:24 PM. Reason: mispelled word

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