But later, you wrote,I'm trying to calculate a formula that is trying to divide a cell that is ZERO...
The error you are getting is not caused by "trying to divide a cell that is ZERO" (that is, cell H23). That will return a 0, not an error. The error you are getting is because you are dividing by zero (that is, cell G23). It's okay if H23 is zero, but not that G23 is zero.H23/(G23*$J$1)*G23
where H23 equals zero, (as a result of another formula)
G23 equals zero, (as a result of another formula)
and J1 equals 152
this is showing up as #DIV/0!
Okay I tried that but it's now giving an answer of undefined, (which does not work either because I'm adding these elsewhere later on).
Is it not possible just to have it say 0??