NO PROBLEM. I HAVE BEEN HELPED SO MANY TIMES BY THIS GROUP,IT MAKES A CHANGE
FOR ME TO HELP SOMBODY

Stew

"Ravi" wrote:

thank U stew.........................

"stew" wrote:

=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