ssblue

asked on

# Excel formula to show $0.00 if negative number.

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

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

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Lee, yours shows >0

Rgonzo, yours shows $0.00 all the time - it should show the calculation if it is a positive number.

Rgonzo, yours shows $0.00 all the time - it should show the calculation if it is a positive number.

Had a typo - I corrected, try again.

corrected code

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

ASKER

Thanks

How about

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

pls try

Open in new window

Regards