IF function nesting issue

csch123

New Member
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?

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
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)

Last edited:

Replies
2
Views
250
Replies
1
Views
159
Replies
2
Views
276
Replies
14
Views
372
Replies
2
Views
131

1,203,667
Messages
6,056,643
Members
444,879
Latest member
suzndush

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back