View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
slacey slacey is offline
external usenet poster
 
Posts: 1
Default Use of IF function with years and months

I'm trying to use IF function with Years and Months in the cell being used to
perform logical argument and it does not appear to work.
I am trying to return different answers for a period of more than 2 years.
If numerical data in Cell shows more than 2 years, 0 months, IF true I want
to display "2+ years" if less than 2 years 0 months I want to display "Under
2 Years"
Any suggestions