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.
Bookmarks