I've searched all over the forums and lots of users encounter this error, and most times it appears related to a missing comma in the statement, which doesn't permit excel to evaluate it correctly. I've double checked my formula about 10 times now and I can't see where this is an issue, nor can I find what could be creating the error.

Basically I started with the formula below which works beautifully.

=IF(ISBLANK($C$4)=FALSE,IF(A112-$C$4<0,"",IF(AND(A112-$C$4>=0,A112-$C$4<14),800,IF(AND(A112-$C$4>=14,A112-$C$4<=377),0,30.77))),"")

Then I added in the following addition in place of the 30.77 highlighted red above. That's when I get the error.

IF(E13-E12<>0,"",30.77)

So that the final formula is:

=IF(ISBLANK($C$4)=FALSE,IF(A13-$C$4<0,"",IF(AND(A13-$C$4>=0,A13-$C$4<14),800,IF(AND(A13-$C$4>=14,A13-$C$4<=377),0,IF(E13-E12<>0,"",30.77)))),"")

I've walked through the evaluation several times and I can't see why it's not acceptable. Any feedback would be awesome. Thanks in advance.