logical test for if statement

[Patty Can]

I am trying to age some outstanding checks in an excel formatted 'register'. I have created columns to the right of the data entries for "1 year", "2 years", etc. representing the length of time that the check has remained outstanding. I am trying to write the formula for 2 years, 3 years , etc.

I have decided to use the logical if formula to have the dollar amount of the check fill in in the appropriate column based on # of years outstanding. I have already created a formula that gives the total number of days outstanding for each outstanding. That formula is in a column of its own.

Now I need to build the if formula that says if, for example, the value is cell N2 (# of days outstanding) is greater than 366 but less than 1095, then enter the dollar amount of the check, if not then enter "0". I don't know how to write the greater than 366 but less than 1095 into the formula.Can anyone help me with this?

 

[njimack]

=if(and(n2>366,n2<1095),a2,0)

EDIT: You could combine this with the age formula. Something like:

=IF(DATEDIF(M2,TODAY(),"y")>3,0,A2)
where M2 contains the date of the check and A2 contains the value

 

[Patty Can]

Let me correct that, the range should read 'greater than 365 and less than 731'. Not that this info really matters at this point.

 

[Patty Can]

Thank you so much!

 

[njimack]

Let me correct that, the range should read 'greater than 365 and less than 731'. Not that this info really matters at this point.

In that case, amending the formula above:

=IF(DATEDIF(M2,TODAY(),"y")>2,0,A2)