View Single Post
  #1   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)

I used the following formula to ask MS Excel to compare two age fields to see
if they are within one year (plus or minus) of matching each other. (It
returned all "NO" answers, which was incorrect).

=IF(((B2=C2)*OR(B2=C2+1)*OR(B2=C2-1)*OR(B2+1=C2)*OR(B2-1=C2)),"YES","NO")

'Suggestions, please?