I did as you asked.

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


=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,IF(E13-E12<>0,"",30.77)))),"")