IF function nesting issue

[csch123]

Hello,

I currently have an equation within excel that I cannot seem to figure out. I am attempting to pull data from three separate cells within my spreadsheet. The equation is written as follow:

=IF(D6="","",D6*-1)+IF(G6="","",G6*-1)+IF(J6="","",J6*-1)

The result is always #VALUE! unless there isa number in ALL of the referenced cells. I'd like for the result to be a blank cell if no values are found in any of the referenced cells, or I would like it to show the value if it finds a number in any of the referenced cells (even if one of the referenced cells is equal to 0). For example, if value was 2 in D6, 4 in G6, and blank in J6, then the result would be 6, not #VALUE!.

What is wrong with my equation?

 

[Jonmo1]

Each of the IF's return a Null Text String ("") if the IF is true.
Number+"" = Error

Try
=IF(D6="",0,D6*-1)+IF(G6="",0,G6*-1)+IF(J6="",0,J6*-1)