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")))
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")))