if statement--issue

[bluepenink]

Hello,

this is the if statement I have currently...

=IF(P10>'Summary 2011'!$M$25,myArrowUp,IF(AND(P10>='Summary 2011'!$P$33,P10<='Summary 2011'!$P$35),MyArrowEqual,myArrowdown))

basically, it stating that:
if P10 > 10% of value, then arrow up
if P10 => 0 ..and...P10 <= -9.99% then arrow equal

for all others, arrowdown

CHANGE to be made:
I was wondering if someone can help me with the logic placement, basically, i want to insert in there,

if P10 is between -9.99% to 0, then show arrow equal.

im struggling with incorporating that portion into my statement; any help?

cheers

 

[Gerald Higgins]

if P10 => 0 ..and...P10 <= -9.99%

This formula is never going to return TRUE

 

[bluepenink]

so there is no way to define that criteria into the if statement?

 

[Gerald Higgins]

You can certainly define it into an IF statement.
But it's never going to return TRUE, so why bother ?

Look at it this way

Value of P......... >=0 ? ...... <-9.99 ? ...... Combined ?
1.......................TRUE........FALSE.............FALSE
0.......................TRUE........FALSE.............FALSE
-5.....................FALSE.......FALSE.............FALSE
-10....................FALSE.......TRUE..............FALSE

 

[bluepenink]

what if it includes

-0.99 to -9.99?

would that work better? thxs for your help!

 

[Gerald Higgins]

I think the most important thing is for you to be really clear about what you want to do.
In your original post, did you mean to say

if P10 => 0 ..and...P10 <= 9.99% then arrow equal

See the difference ?

 

[bluepenink]

Hello

thx for your response; and sorry for the confusion.

bascially i would like everything to remain the same, EXCEPT for

if this portion can be incorporated as well, the between portion

P10 <= -0.1....and P10 <= -9.99, then "equal sign"
(basically between -0.1 and -9.99)

im having trouble placing that into my if statement

original if statement
=IF(P10>'Summary 2011'!$M$25,myArrowUp,IF(AND(P10>='Summary 2011'!$P$33,P10<='Summary 2011'!$P$35),MyArrowEqual,myArrowdown))

 

[bluepenink]

Hello Gerald

thxs for the help but ive managed to solve it

=IF(P91>10%,myArrowUp,IF(AND(P91<=9.99%,P91>= -9.99%),MyArrowEqual,myArrowdown))

 

[Gerald Higgins]

Well done and thanks for letting us know it's been solved