To calculate non real roots:
Real1:
=(-B1+IF(B1^2-4*A1*C1<0,0,B1^2-4*A1*C1)^0.5)/(2*A1)
Imaginary1 (if needed):
=IF(B1^2-4*A1*C1<0,(-1*(B1^2-4*A1*C1))^0.5/(2*A1),"")
Real2:
=(-B1-IF(B1^2-4*A1*C1<0,0,B1^2-4*A1*C1)^0.5)/(2*A1)
Imaginary2 (if needed):
=IF(B1^2-4*A1*C1<0,(-1*(B1^2-4*A1*C1))^0.5/-(2*A1),"")
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*