Thread
:
Using Function IF
View Single Post
#
2
Nick Hodge
Posts: n/a
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?
Reply With Quote