Support Board

Date/Time: Sat, 30 Nov 2024 02:47:42 +0000

Post From: Spreadsheet don't recognize formulas

[2023-01-04 17:20:04] Link To Thread - Link To Post [Go To First Post]
Hopeman - Posts: 166
Hi, good, I'm trying to establish two inputs in different situations, apparently I can't find the formula in question, the formula to cross the High regression line until everything is fine, The problem is fine when I write the IF variable if one is not true, apply the another, the following formula applies to the regressive line in the middle, on the other hand, I need the output to be with a certain volume input and if that input is not given that closes unless the tiks indicated, the first input formula is the Next ) =If(AND(CROSSFROMBELOW(E3:E5,AB3:AB5),AND(CROSSFROMBELOW(AM3:AM5,AW3:AW5),O3,Q3),IF(OR(AND(CROSSFROMBELOW(E3:E5,AB3:AB5) , AND(CROSSFROMBELOW(AM3:AM5,AV3:AV5), O3, Q3)))))) For the output I am trying to combine this with the variation if there is no output volume that the least tiks are applied. =AND(CROSSFROMABOVE(AM3:AM5,AW3:AW5),Q3),OR(AND($J$10/$J$56<-12)) Kimng regards.