We help IT Professionals succeed at work.

Excel formula to show $0.00 if negative number.

125 Views
Last Modified: 2017-03-10
I need the following formula to show $0.00 if it is a negative number, otherwise perform calculation.

="Avoided Spend w/ Reference = "&TEXT('SSG 2017 Orders'!AT2,"[$$ -409]#,##0.00")
Comment
Watch Question

Technology and Business Process Advisor
CERTIFIED EXPERT
Most Valuable Expert 2013
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2016

Commented:
Hi,

pls try
="Avoided Spend w/ Reference = "&TEXT(A3,"[$$ -409]#,##0.00;""$ 0.00""") 

Open in new window

Regards
ssblueCoordinator

Author

Commented:
Lee, yours shows >0

Rgonzo, yours shows $0.00 all the time - it should show the calculation if it is a positive number.
Lee W, MVPTechnology and Business Process Advisor
CERTIFIED EXPERT
Most Valuable Expert 2013

Commented:
Had a typo - I corrected, try again.
CERTIFIED EXPERT
Top Expert 2016

Commented:
corrected code
="Avoided Spend w/ Reference = "&TEXT('SSG 2017 Orders'!AT2,"[$$ -409]#,##0.00;""$0.00""") 

Open in new window

ssblueCoordinator

Author

Commented:
Thanks
CERTIFIED EXPERT

Commented:
How about

="Avoided Spend w/ Reference = "&IF('SSG 2017 Orders'!AT2<0,"0.0",TEXT('SSG 2017 Orders'!AT2,"[$$ -409]#,##0.00"))

Open in new window