If function required
But please realise that Stew's suggestion looks for numbers greater than
zero (and would also pick up text values), rather than looking for any
number.
So abc would give Paid, but -27 would give a blank.
If you do want to use his logic, you can throw away some of the parentheses
and reduce
=IF(A1="",("Unpaid"),IF(A10,("Paid"),(""))) to
=IF(A1="","Unpaid",IF(A10,"Paid",""))
--
David Biddulph
"stew" wrote in message
...
=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
|