Click here for important information about Computing.net.

Creating Indicators in Excel

Tags:
Microsoft Office excel 2007 home & stude...
excel
September 8, 2010 at 18:46:29
Specs: Windows XP
Hi,
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.

Thanks,
Neha


See More: Creating Indicators in Excel

Report •

#1
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 •
Start a discussion
Related Solutions
See More ↓


Ask Question