Simple Formula needed please!

[Bob Vance]

--
In B1 I want:
If A1 >0 "Overdue Balance", =0" " , <0 "Credit"



Thanks in advance for your help....Bob Vance

 

[Kieran]

In B1 enter

=if(A1 >0, "Overdue Balance",if(a1=0," ","Credit")

 

[John Wilson]

Bob,

=IF(A1=0,"",IF(A1>0, "Overdue Balance", "Credit"))

John

 

[Norman Harker]

Hi Bob!

This is how I would attack it:

=IF(A1="","",IF(A1<0,"Credit",IF(A1=0,"Balance","Overdue Balance")))


The base formula:
=IF(A1<0,"Credit",IF(A1=0,"Balance","Overdue Balance"))

Works logically from negative, through zero to positive
This is then nested in a further IF function that returns "" if A1 is
""


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Harlan Grove]

In B1 I want:
If A1 >0 "Overdue Balance", =0" " , <0 "Credit"

...

Yet another alternative.

=CHOOSE(2+SIGN(A1),"Overdue Balance","","Credit")