How do I fomulate "2 years but less than 4 years" using nested if/and?
O OssieMac Apr 16, 2008 #2 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)
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)
B BoniM Apr 16, 2008 #3 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),...
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),...
