M
Moses Bunting
Cell A1 = '=COS(PI()/4)/TAN(PI()/4)' gives 0.7071...
Cell A2 = '=SIN(PI()/2)*SIN(PI()/4)' also gives 0.7071...
Cell A3 = '=A1-A2' gives 0.0000E00 but
Cell A4 = '=(A1-A2)' gives 2.2204E-16
The only difference between the formulas in A3 and A4 are the parentheses.
Cell A2 = '=SIN(PI()/2)*SIN(PI()/4)' also gives 0.7071...
Cell A3 = '=A1-A2' gives 0.0000E00 but
Cell A4 = '=(A1-A2)' gives 2.2204E-16
The only difference between the formulas in A3 and A4 are the parentheses.