Creating Indicators in Excel

Microsoft Office excel 2007 home & stude...
September 8, 2010 at 18:46:29
Specs: Windows XP
I am not sure how to create indicators on a report i am working on based on the scenarios -
a ) 1 M -2M - Tier 1
b ) 500 K - 1M - Tier 2
c) 250 K - 500 K - Tier 3
d) Under 250 K - Tier 4

This needs to be on the top right of the report. Would the if function do?

Any help would be appreciated.


See More: Creating Indicators in Excel

Report •

September 8, 2010 at 19:51:28
What do you mean by indicators?

As far as I know the only time the term indicators is used in Excel is when they're talking about Comment or Error indicators.

If you are trying to return a specific Text string based on an amount in a cell, then an IF statement might work, as well as VLOOKUP.

However, there are a couple of issues with your example data.

1 - Other than Tier 4, your Tiers overlap. Tier 2 starts at 500K and Tier 3 ends at 500K. Tier 1 starts at 1M and Tier 2 ends at 1M. Is it supposed to be that way?

2 - Maybe it's not possible, but you don't say what Tier a value over 2M would belong in.

Report •
Related Solutions

Ask Question