Support Board

Date/Time: Sun, 19 May 2024 10:52:39 +0000

Post From: Understanding Spreadsheet Formula Examples

[2018-05-05 09:07:23] Link To Thread - Link To Post [Go To First Post]
User172040 - Posts: 70
Hi, I'm learning the spreadsheet formulas and just need to put words to the formulas in order to understand it better. Under Multiple Exit Automated Trading Example (Spreadsheet Systems, Alerts and Automated Trading: Multiple Exit Automated Trading Example ) you display the following code: =IF( ABS(J8) = 5, 2, IF( ABS(J8) = 3, 3, 0)). In order for me to understand this, how do I word this? Something like IF Position Quantity (J8) = 5 contracts, then (what does the 2 represent?) AND IF Position Quantity (J8) = 3 contracts, then (what does the 3 represent), then (what does the 0 represent?) If you give worded examples of spreadsheet formulae, can you kindly direct me in the right direction. Date Time Of Last Edit: 2018-05-06 22:15:46