How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Pete Your Own Question

Pete
Pete, Computer Expert
Category: Microsoft Office
Satisfied Customers: 15775
Experience:  MS Office expert
30970729
Type Your Microsoft Office Question Here...
Pete is online now
A new question is answered every 9 seconds

=SUM(D12,G12,J12,M12,P12)/SUM(E12,H12,K12,N12,Q12) how do I

This answer was rated:

=SUM(D12,G12,J12,M12,P12)/SUM(E12,H12,K12,N12,Q12) how do I make this into a if formula so that if I have a zero it shows zero?
Hello,
I am Pete, and I'll be happy to assist with your question today.

The formula you require is:

=IFERROR(SUM(D12,G12,J12,M12,P12)/SUM(E12,H12,K12,N12,Q12),0)

Customer: replied 4 years ago.


That is not correct, the 1 I have found works is =IF(SUM(E12,H12,K12,N12,Q12)=0,"0",SUM(D12,G12,J12,M12,P12)/SUM(E12,H12,K12,N12,Q12))

Hi Jim,

Both versions of the formula will give the correct answer.

Pete.
Pete and other Microsoft Office Specialists are ready to help you