In all cases, what were the values of the cells involved? What answers did
you get?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Text Cell Computations" <Text Cell
wrote in message ...
=IF(c2="ABC",TRUE,FALSE) doesn't do anything
=(a2 & b2) doesn't concatenate 2 text cells
=CONCATENATE(A2,B2) DOESN'T CONCATENATE 2 CELLS

All arithmetic computations seem to work OK