microsoft excel 2007
 

How do I fomulate "2 years but less than 4 years" using nested if/and?

microsoft excel 2007
 

The following returns TRUE if A1 is equal to or greater than 2 and equal or
less than 4.

=IF(AND(A1=2,A1<=4),TRUE,FALSE)
--
Regards,

OssieMac


"confusious" wrote:

How do I fomulate "2 years but less than 4 years" using nested if/and?

microsoft excel 2007
 

If cell A1 contained number of years:
=IF(AND(A1=2,A1<4),...

if cell A1 contains a date and you're comparing to todays date:
=IF(AND(TODAY()-A1=730,TODAY()-A1<1461),...


Confusious" wrote:

How do I fomulate "2 years but less than 4 years" using nested if/and?

microsoft excel 2007
 

Read a book on elementary Excel?

"confusious" wrote in message
...
How do I fomulate "2 years but less than 4 years" using nested if/and?