Help with nested IF statement

[DPChristman]

Essentially what I am trying to do is

Calculate number of years by subtracting entered date (T5) form original data (C5)

Currently, my formula reads =IF(T5="n/a","",YEAR(C5)-YEAR(T5))

As a result, if T5 contains n/a, the cell will return a blank field.

However, I would also like to add =IF(T5="","",YEAR(C5)-YEAR(T5)), so the same result is returned if the field is empty.

I have tried =IF(T5="n/a",",",IF(T5="","",YEAR(C5)-YEAR(T5)) With no success. Is there an easy way to do this?

 

[Scott T]

=IF(OR(T5="n/a",T5=""),"",YEAR(C5)-YEAR(T5))

 

[CDelSignore]

You want it to display a blank field if T5 is n/a or blank? Try:

=IF(T5="n/a","(removed comma)",IF(T5="","",YEAR(C5)-YEAR(T5))
​

In your first If statement, if T5="n/a", because you used single quotes around a comma, the comma was inserted in the field. Essentially, getting rid of that comma, gives you a blank field.

 

[DPChristman]

=IF(OR(T5="n/a",T5=""),"",YEAR(C5)-YEAR(T5))

Thanks, worked perfect!

 

[DPChristman]

Thanks