If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
3 Flag Icon Set not computing correctly
In an assignment for college, we used the 3 flag icon set to conditionally
format a column of revenues with $110,000 being the highest value. Any ideas why the flag levels would not be computing correctly? We used the default rule to green flag values = 67 percent, etc. The green flags included the revenues $110,000-$85,000; yellow flags $78,000-55,000; and red flags $50,000-$25000. Thanks for your insights. |
#2
|
|||
|
|||
3 Flag Icon Set not computing correctly
Sorry, this is microsoft.public.excel.worksheet.functions.
mindreading.crystal.ball is next door. Why not tell us what conditions you are using in CF, what value you had in the relevant cells, what result you got, and what result you expected? Also, what version of Excel are you using, and what do you mean by the "3 flag icon", as that is not a term with which I am familiar in Excel 2003? Don't forget that if you are referring to percentages, Excel will need to know percentages of what. If you are looking for 67% of 110000, your test would need to say 110000*67% or 73700; you coudn't get away with saying just 67%, but of course you could test for =A2/11000067% if you wished. -- David Biddulph "Melody" wrote in message ... In an assignment for college, we used the 3 flag icon set to conditionally format a column of revenues with $110,000 being the highest value. Any ideas why the flag levels would not be computing correctly? We used the default rule to green flag values = 67 percent, etc. The green flags included the revenues $110,000-$85,000; yellow flags $78,000-55,000; and red flags $50,000-$25000. Thanks for your insights. |
#3
|
|||
|
|||
3 Flag Icon Set not computing correctly
Excel 2007: Home tab/Styles/Conditional Formatting/Icon Sets/3 Flags
Then to edit the rule: Home tab/Styles/Conditional Formatting/Manage Rules/Edit Rule/Dialog box I have a column of revenues (,000 omitted for brevity's sake): 25, 30, 32, 35, 37, 39, 45, 45, 45, 45, 48, 50, 55, 56, 65, 65, 67, 75, 76, 76, 78, 85, 92, 95, 95, 100, and 110. After selecting the cells in the column and following the above routine, the following result was returned: Revenues $85,000 and greater returned a green flag Revenues $55,000 through $78,000 returned a yellow flag Revenues $25,000 through $50,000 returned a red flag The rule was set such: Green flag = 67 percent Yellow flag = 33 percent and 67 percent Red flag 33 percent Therefore, I expected green flags returned for revenues = $73,700 and so forth. You are exactly correct when you say I need to designate 67% of what, but unfortunately the dialog box does not allow for that and that is the million dollar question I have--what value does Excel use to compute this rule?? Not knowing what to expect, I expected Excel to look at the list of values, select the highest value and make the computations from there. However, it doesn't seem to work like that. "David Biddulph" wrote: Sorry, this is microsoft.public.excel.worksheet.functions. mindreading.crystal.ball is next door. Why not tell us what conditions you are using in CF, what value you had in the relevant cells, what result you got, and what result you expected? Also, what version of Excel are you using, and what do you mean by the "3 flag icon", as that is not a term with which I am familiar in Excel 2003? Don't forget that if you are referring to percentages, Excel will need to know percentages of what. If you are looking for 67% of 110000, your test would need to say 110000*67% or 73700; you coudn't get away with saying just 67%, but of course you could test for =A2/11000067% if you wished. -- David Biddulph "Melody" wrote in message ... In an assignment for college, we used the 3 flag icon set to conditionally format a column of revenues with $110,000 being the highest value. Any ideas why the flag levels would not be computing correctly? We used the default rule to green flag values = 67 percent, etc. The green flags included the revenues $110,000-$85,000; yellow flags $78,000-55,000; and red flags $50,000-$25000. Thanks for your insights. |
Thread Tools | |
Display Modes | |
|
|