I have the simplest possible scenario:
=A1*0.4=SUM((A2-A3)/A2)This will print out 0.439679359 but every calculator, plus taking out the sub formula will retu 0.438877756 which is correct.
Why is Excel incorrect when using a sub formula?
برچسب:
نویسنده: استخدام کار