Reflected on that string and tried re-working the formula as:

=IF($S$23>2%,SUM(((J79-4700)+H80+I80))-N80,SUM(J79+H80+I80)-N80)

Seems to return the same answer!

Regards,
Preceptor