If function required

  • Thread starter Thread starter Ravi
  • Start date Start date
R

Ravi

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
 
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","Undefined")) or to
=IF(A1="","Unpaid",IF(ISNUMBER(A1),"Paid","Undefined")) or to ...
 
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(A1>0,("Paid"),(""))) to
=IF(A1="","Unpaid",IF(A1>0,"Paid",""))
 
NO PROBLEM. I HAVE BEEN HELPED SO MANY TIMES BY THIS GROUP,IT MAKES A CHANGE
FOR ME TO HELP SOMBODY

Stew
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to deduct unpaid breaks in time sheet 3
Change Color in a Formula 2
Simple totals 4
How to ignore a column of numbers in Grand Total for rows 1
How do I show info only in cells used 1
I need help with excel IF function 2
IF Function formula (I think?) 4
Comparing data from two columns 2

Back
Top