Login Page - Create Account

Support Board


Date/Time: Sat, 12 Jul 2025 10:01:51 +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 - 176 views
imagespreadsheet with 2 if formulas.png / V - Attached On 2022-10-13 14:13:20 UTC - Size: 141.93 KB - 138 views