ok another question if the vaules are not the same can it display the word
not balance and if it is the same it will display balance?

"jenniss" wrote:

THANKYOU that has worked

"R D S" wrote:

Put into cell C1
=IF(A1=B1,"BAL","")

"jenniss" wrote in message
...
I want a cell to display the word balance

example cell "A" is the same amount in cell "B" cell "C" will say BALANCE

is this possible?