Say the cell to be checked is A2, enter into the "another" cell
=IF(ISBLANK(A2),"a","b")

Regards,
Stefi

€žShamsulZ€� ezt Ã*rta:

Can anybody help me in the if formula whereas if the cell has no value it
will show a in another cell, if has any value it will show b in the another
cell

Thanks