View Single Post
  #4   Report Post  
Gabriele
 
Posts: n/a
Default

Dear chihow,

yes you can. The formula would look liie this: A6=IF(ABS(A1-A2)<2,"yes","no")

"cihow81" wrote:

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?