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 Richard Your Own Question

Richard
Richard, Consultant
Category: Programming
Satisfied Customers: 31118
Experience:  Programming and Network consultancy for 15+ years
32989067
Type Your Programming Question Here...
Richard is online now
A new question is answered every 9 seconds

=IF(P14>0,IF(Z14=3,P14*1000/(1.732*X14*0.8),P14*1000/(X14*0.8)),(O14*0.746)*1000/(1.732

Customer Question

=IF(P14>0,IF(Z14=3,P14*1000/(1.732*X14*0.8),P14*1000/(X14*0.8)),(O14*0.746)*1000/(1.732*X14*0.8))
I AM GETTING A #DIV/0!
IN THIS FORMULA AND I WOULD LIKE TO REPLACE IT WITH A *BLANK* IN THAT CELL.
Submitted: 7 months ago.
Category: Programming
Expert:  Richard replied 7 months ago.
Hi there and welcomeuse this as it should clear it if Div error appears=if(iserror(IF(P14>0,IF(Z14=3,P14*1000/(1.732*X14*0.8),P14*1000/(X14*0.8)),(O14*0.746)*1000/(1.732*X14*0.8)),"",IF(P14>0,IF(Z14=3,P14*1000/(1.732*X14*0.8),P14*1000/(X14*0.8)),(O14*0.746)*1000/(1.732*X14*0.8))) Let me know please how you go.

Related Programming Questions