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!
Hi,
There are some gaps in your buckets.
What do you want to be displayed if P10 equals exactly 10%?
What do you want to be displayed if P10 is >= -10% and < 0%?
Hello Colin
What do you want to be displayed if P10 equals exactly 10%?
a) I would prefer if it's >= + 10%
What do you want to be displayed if P10 is >= -10% and < 0%?
b) if the formula can show "no change" for this critieria
Ive been struggling to incoporate all those, so if you can pls help me, I would be grateful! thx you.
cheers
Hi,
See if this works for you:
It assumes that there can be no values less than -80%, as you outlined in your earlier post.
Please Login or Register to view this content.
Hello Colin,
wow great, thank you so much.
is it possible for the { } portion to use defined named?
i.e. for "up" "down" "no change"
im using symbols (windings 3 to show arrows)....so i have defined arrows but i cant seem to add the &myArrowUp...etc?
ur thoughts and thxs again!
Sure, you want the symbols returned rather than the words?
Change the formula to:
and format the cell containing the formula so it has the Wingdings 3 font.Please Login or Register to view this content.
Last edited by Colin Legg; 05-27-2011 at 01:15 PM.
hello colin
thxs for the grreat help. your awesome!!!! cheers
Last edited by jw01; 05-27-2011 at 01:17 PM.
Sorry, I edited my reply while you were posting. See if the revised version works for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks