| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
| How do I change months into years? | Excel Worksheet Functions | |||
| converting months to years and months??? | Excel Discussion (Misc queries) | |||
| years and months | Excel Worksheet Functions | |||
| function years:months | Excel Worksheet Functions | |||
Threaded Mode
