Nested Formula For Numbers and Text

[jdmaybee]

I have been trying to show a numeric total as mixed text and numeric like this:

Balance $xxx,xxx.xx down to Balance $-xx,xxxx.xx


The following formula works nicely for amounts over $10.00 but it always shows anything less than zero as Balance $-x,xxx.xx


Does anyone know how I can get it to display the negative dollar figures without a leading minus and bracket the figures? eg., Balance $(9,234.75)


=IF(F1>999.99,"Balance $"&TEXT(F1,"0,000.00"),IF(F1<1000,"Balance $"&TEXT(F1,"00.00")))

 

[Hui]

Just have the value in the cell and

Try the Custom Number format Ctrl 1

"Balance "$ #,##0;"Balance "$- #,##0

 

[jdmaybee]

Too easy!! Thanks