formuale help

Copper Contributor

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

2 Replies
You need to attach a sample file and explain what you intend to achieve

@Gavc1 

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.