View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Certainly

=IF(ABS(A1-A2)<2,"Yes","No")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"cihow81" wrote in message
...
Cell A1 is a variable
Cell A2 is a variable
Cell A6=IF(ABS(A1-A2)<2,TRUE,FALSE)

Instead of Displaying True and False when data are inserted into the
cells,
could i display other words, such as YES and NO? If can, how do i do it?