Need Help with IF Function

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I need to calculate column U7.
Here is my statement: =IF(S7>5,"Mature",S7&" Yrs")
If I run this statement, any record that does not meet this criteria (>5)
returns with a serious of digits, e.g. 4505494 in a column U7

The S7 cell icontains a count of years, which is calculated with this
statement: =(DATE(2008,2,3)-P7)/364

What I want to get is:

P7 S7 U7
Open Date Years Opened (full yrs) Maturity
2/24/2005 3 3Yrs
5/9/1997 11 Mature

Please help
 
Hello Andy,

Just happenned to have done something similar not to long ago. Try using
something along the lines of:

=ROUND(YEARFRAC(P7,Date(2008,2,3),3),0)

for the formula in S7

Thell
 
Back
Top