Thread: Accuracy
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ad Pronk Ad Pronk is offline
external usenet poster
 
Posts: 2
Default Accuracy

Using Excel 2003 I "discover" a strange thing. Placing brackets around a term
introduces an inaccuracy. Is this normal?
1-(1/cos(x)*cos(a.t+x) is nil for t=0 as it should be. But I use this term
in a series, so I have to place brackets around the term:
(1-(1/cos(x)*cos(a.t+x))
And surprisingly for t=0 I get the answer 1.1 E(-14).
It's small but I expect at least a value below E(-22) or 0

Reactions are welcomed
Ad Pronk