Nested IF function error "You've entered too many arguments..."

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.

I did as you asked.

I had no issues. Perhaps it is your version of excel.

Please Login or Register  to view this content.

Originally Posted by mehmetcik

I did as you asked.

I had no issues. Perhaps it is your version of excel.

Please Login or Register  to view this content.

Originally Posted by Mazzaropi

lovetofly32, Good evening.

I tested your formula WITH NO MODIFICATIONS and IT'S OK!

Take a look at it.
Attachment 339125

Is it what you want?
I hope it helps.

That's kinda weird. After your response I copied and pasted the formula into a blank spreadsheet, and then back into the original cell I created it in and it worked fine. Thank you both for the feedback! Good to go now.