Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 16:46:01 +0000



Post From: SC Historical Data Feed with Spreadsheet Quotes

[2014-09-14 17:03:29]
Trint - Posts: 115
... could I use something like the following formula, posting it in L3 or is there something easier or something more 'involved' I need to do. Would I be on the right track..?

in L3
=IF(N3>=L3, L3=N3) for posting the HIGH

in M3
=IF(N3<=M3, M3=N3) for positing the LOW

where N3 is the last, L3 being the HIGH, M3 the LOW