Support Board

Date/Time: Fri, 19 Apr 2024 15:21:23 +0000

Post From: 6E spreadsheet B, C, D, E columns

[2014-01-09 16:41:55] Link To Thread - Link To Post [Go To First Post]
User60591 - Posts: 39
Pls tell me why do I have in a spreadsheet the value of 6E on 15 decimals, instead of 4 (Open, High, Low , Last? i.e 1,35909998416901 (double clicking the cell) instead of just 13510, and then the first number is rounded up to get 13510. Namely I use formula =AND(B3=D3;E3=C3;E3>B3;B3<=E4) as a part of a buying signal I have following on 2014/1/8 @ 11:55:32 (GMT+1) open B = 1.3578999 high C = 1.35829997062683 low D = 1.35790002346039 last E = 1.35829997062683 so I have FALSE because Open and Low does not match. Rounded up it would be TRUE 1.3579 1.3583 1.3579 1.3583 Pls help me with this. thank you Date Time Of Last Edit: 2014-01-09 16:45:45