Need Help with IF Function

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
 
T

Thell Fowler

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Function 1
Help with a nested IF statement containing AND and OR funtions 1
Excel PRICE function: How does it compute Issue Date of the Security 5
Need Help With YIELDMAT 6
Need Help with a VBA subroutine 0
Help with time function 7
Help with IF/AND function 14
IF and IF and IF 6

Top