if statement logic...help!

[bluepenink]

Hello...i got a pretty basic if statement but im struggling with placing the logic behind my formula

basically, i trying to achieve the following:

=IF(N17>10,myArrowUp,myArrowdown),if(N17=0,myArrowEqual,))

so im trying to say, if N17 = 0 then myArrow Equal, but if N17>0, then my arrowup else my arrow down.


can someone help! thxs!!!

 

[Peter_SSs]

Hello...i got a pretty basic if statement but im struggling with placing the logic behind my formula

basically, i trying to achieve the following:

=IF(N17>10,myArrowUp,myArrowdown),if(N17=0,myArrowEqual,))

so im trying to say, if N17 = 0 then myArrow Equal, but if N17>0, then my arrowup else my arrow down.


can someone help! thxs!!!

Unclear if N17 needs to be greater than 10 or 0 but try this sort of structure

=IF(N17>0,myArrowUp,if(N17=0,myArrowEqual,myArrowdown))

 

[njimack]

=IF(N17=0,myArrowEqual,IF(N17>10,myArrowUp,myArrowdown))

 

[bluepenink]

Hello guys

thxs alot!

if i can add to Pete's point, can i implement a request in the formula so it only applies this logic if the variance is greater than 10%?

basically, i got two formulas

a) variance: M16-L16

b) if statment: =IF(N17>0,myArrowUp,if(N17=0,myArrowEqual,myArrowdown))

but if my variance, is it possible to place an if statement, so it only extracts a variance, if the variance exceeds 10% + or -?

 

[Peter_SSs]

basically, i got two formulas

a) variance: M16-L16

b) if statment: =IF(N17>0,myArrowUp,if(N17=0,myArrowEqual,myArrowdown))

but if my variance, is it possible to place an if statement, so it only extracts a variance, if the variance exceeds 10% + or -?

One of those formulas refers to row 16, the other to row 17 but assuming they were both meant to refer to the same row, is this what you mean?

=IF(ABS(M17-L17)>0.1,IF(N17>0,myArrowUp,if(N17=0,myArrowEqual,myArrowdown)),"")

or if N17 contains the variance formula
=M17-L17
then try your original formula with 0.1 in place of the 10:

=IF(N17>0.1,myArrowUp,if(N17=0,myArrowEqual,myArrowdown))