Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function required
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function required
=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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function required
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function required
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function required | Excel Discussion (Misc queries) | |||
If function with two results required | Excel Worksheet Functions | |||
add OR to already nested If function - help required | Excel Worksheet Functions | |||
Count Function help required | Excel Worksheet Functions | |||
Count function required | Excel Discussion (Misc queries) |