If function required
Quite a few things you've left undefined. You've talked about numbers in
A1, but not about text, nor about empty text strings.
You might change your formula from
=IF(A1," ","Unpaid") to
=IF(A1,"Paid","Unpaid") or to
=IF(ISNUMBER(A1),"Paid","Unpaid") or to
=IF(A1<"","Paid","Unpaid") or to
=IF(ISBLANK(A1),"Unpaid",IF(ISNUMBER(A1),"Paid","U ndefined")) or to
=IF(A1="","Unpaid",IF(ISNUMBER(A1),"Paid","Undefin ed")) or to ...
--
David Biddulph
"Ravi" wrote in message
...
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
|