I need to make these forumulas not show #DIV/0!

[SETH777]

I need to have these not show that I am dividing by 0. I just dont know how to write the IF error into it. thank you for your help

=(SUM(M4:M1079)-SUM(L4:L1079))/ABS(SUM(M4:M1079))

=(SUM(G2:G1079)-SUM(L2:L1079))/ABS(SUM(G2:G1079))

=(M4-L4)/ABS(M4)*100

=(G4-L4)/ABS(G4)*100

Bonus question: Is there a way to make my formulas lock to a cell and not be able to be altered, but still be able to enter text and highlight and change the sheet?

[TMS]

Q1: use IFEROR.

Q2: unlock the cells where you want input and then protect the sheet.

Regards, TMS

[SETH777]

I appreciate your help
but i do not know how to write the IF ERROR into the formulas

[ChemistB]

IFERROR works like this
=IFERROR(your formula, what you want if there's an error)

So for first formula

=IFERROR((SUM(M4:M1079)-SUM(L4:L1079))/ABS(SUM(M4:M1079)), "") returns a null set on error

[SETH777]

this worked!
thank you