View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Douglas Eckert Douglas Eckert is offline
external usenet poster
 
Posts: 32
Default Nested Ages Plus or Minus (IF)

Dave O: Thanks.

DOUG

"Dave O" wrote:

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