Divde by zero Error

G

Guest

Please help with the following formula,
E20 and E22 , when left blank = value of 0, Therefore " Divide by Zero
Error " condition occure affecting the rest of the form.
example =sumif(E20,E22)=<0*(E2/E22)*167
 
G

George Nicholson

Not at all sure what you are asking/trying to do, but my best guess
(avoiding DivisionByZero error while ignoring incorrect SumIf syntax) is:

=If(E22 = 0, 0, (E2/E22)*167)

HTH,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Divide by Zero 3
Divide by the minimum non-zero number in a range of cells 21
Division by Zero Error 5
Divide by zero error 3
Error: Block If without End If 2
excel divide by zero error 5
divide by zero 3
How do I average cells that contain #DIV/01? 2

Top