excel - Value Error when entering formula -

My code works fine in my test sheet, but when I put it in my active sheet, Get the error ... any suggestions? I really do not know what I'm doing wrong, really pulling out my hair

The code below works perfectly in my test sheet and returns all the values ​​correctly, Either way when I put it in a sheet that matters, boom value error (<10: A610 = "No" (E10: I610 * 0.056,0)) + SUM ((E10: I610 & gt; 34760) * ROUND (34760 * 0.056,0)), 0)

I agree with the dog - suppose you do not have any errors in the referenced category That #VALUE! Error is just trying to apply a round function to a text value - this version should avoid the error

= IF (J5 = "YES", SUM (if (E10: I610 & gt; 11538, if (E10: I610 & lt; = 34760, IF (A10: A610 = "No", ROUND (E10: I610 * 0.056,0)), IF (ISNUMBER (E10) : I610), ROUND CTRL + SHIFT + ENTER

Has been confirmed with (34760 * 0.056,0))) / Kbd>

..... But check the result because the expected result may be affected

Note: If E10: I610 is> 34760 then Regardless of the column A value (according to your formula) in 34760 * 0.056 goals (i.e. 1947) in Dashi, is it intended?

Your comment should be re - this revised version should be done to you < / P>

= IF (J5 = "YES", SUM (IF (E10: I610 & gt); 11538, IF (A10: A610 = "No", IF (ISNUMBER (E10: I610) ROUND (if (E10: I610 & gt; 3476034760, E10: I610) * 0.056,0)))), 0)