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?
|