View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Nested Ages Plus or Minus (IF)

How about
=IF(ABS(A1-B1)<=1,"Yes","No")
where A1 and B1 are the age fields.