Hello

Im have the following if statement, but not getting the correct reading or answer....

=IF(P10>'Summary 2011'!$K$16,"Up",IF(OR(P10='Summary 2011'!$O$24,P10=0),"no change","Down"))

range P = percentages from -80% to +1000%

what im tryign to achieve is....

if P10 > 10% then "Up"

if P10 < -10% then "down"

if P10 is in between 0 to +9.99% then "no change"

can someone help me with placing the logic, thxs alot!