Feb 26 2020 03:32 PM
I have a formulae =(A34/(C34-B34)*D34)+B34/2 however if no figures are input it gives me a divxerror how do i not get this im not quite understanding t
Feb 26 2020 03:41 PM
Feb 26 2020 09:36 PM
Perhaps, you need to wrap your formula with IFERROR like this:
=IFERROR(A34/(C34-B34)*D34+B34/2,0)
Note that the above formula returns 0 if your original formula results in an error.