Thread: microsoft excel 2007
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OssieMac OssieMac is offline
external usenet poster
  
Posts: 2,510
Default 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?
Reply With QuoteReply With Quote