=IF(A1="",("Unpaid"),IF(A10,("Paid"),("")))


"Ravi" wrote:

Hi...........If A1 is blank then B1 is "Unpaid" if A1 has numbers then B1 is
"Paid"

i tried the below for "unpaid" and its ok and i need to add the "Paid" also
in this formula
=IF(A1," ","Unpaid")

please help..............

regards,
ravi kumar