DIV/O Error

M

Melissa

Here is the wrong way:
=IF(B91/(D4*D87+E4*E87+F4*F87+G4*G87+H4*H87+I4*I87),(B91-(D4*D87+E4*E87+F4*F87+G4*G87+H4*H87+I4*I87))*0.5+(D4*D87+E4*E87+F4*F87+G4*G87+H4*H87+I4*I87)*0.166722)

This example was kindly provided and I must post for those at my level to
learn the better practice approach.

=IF(SUMPRODUCT(D4:I4, D87:I87)=0, "", IF(B91<>0, B91/2 -
SUMPRODUCT(D4:I4, D87:I87) * (0.5 - 0.166722),""))


Thanks jem!
 

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

Full page formulas 1
Formulate Entire Sheet 2
Leave final cell blank 2
How do I ignore blank cells while averaging the solutions of equat 2
if function error 3
Problem with IF statements 1
Code Needed for to check data input 2
if statement 1

Top