Put the other word between the second quotes ie

=IF(A1=B1,"BAL","NOT BAL")

Glad to be of help, I usually just post questions!
Rick

"jenniss" wrote in message
...
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?