If negative/positive

[jmaskin]

I am trying to return specific text based on whether a number in a different cell is positive or negative.
In other words, If B11 Is positive then A11 should read Balance Due, If B11 is negative A11 should read Credit Due

 

[Phuoc]

If B11 = 0 what is the desired result?

 

[jmaskin]

I suppose "Balance Due"

Side bar, is there a way to make it show as a positive number? I am trying to create an invoice. However, sometimes they will owe, other times they will get credit

 

[Phuoc]

Try this:

=IF(B11<0,"Credit Due","Balance Due")

 

[Skyybot]

Book1
	A	B
11	Credit Due	-20
Sheet1

Cell Formulas
Range	Formula
A11	A11	=IF(B11>=0,"Balance Due","Credit Due")

 

[Scott Huish]

Side bar, is there a way to make it show as a positive number? I am trying to create an invoice. However, sometimes they will owe, other times they will get credit

You can use a custom number format like this:
0.00;0.00;0.00