if statement logic prob.

[bluepenink]

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! <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->

 

[Haldoug]

Have you considered condition formating and the between function?