Login Page - Create Account

Support Board


Date/Time: Wed, 19 Mar 2025 08:48:44 +0000



Post From: Calculate wicks movement

[2022-10-13 14:15:51]
awakef - Posts: 72
Good Morning John,
If I do the first IF formula without the other nested it works good on bullish candles but on the bearish ones it gives me 0 value and thats ok because I want to give me a number when the candle is bullish.

Thats why I nested the other if formula so when the candle is bearish give me a value instead of giving 0 of the first if formula when the candle is bullish only.
imagesingle if.png / V - Attached On 2022-10-13 14:12:54 UTC - Size: 197.44 KB - 157 views
imagespreadsheet with 2 if formulas.png / V - Attached On 2022-10-13 14:13:20 UTC - Size: 141.93 KB - 124 views