Ask Experts Questions for FREE Help !
Ask
Page 2 of 2 « First < 2
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #21

    Oct 14, 2009, 12:33 PM

    This will expand up to about 28 items, just add to each array in the correct position, and remember the first array is ordered.

    =LOOKUP(F20, {0,50000,100000,200000,300000,500000,750000,100000 0,1250000}, {"no way","*","**","***","****","*****","Silver","Gold" ,"Platinum"})

    Or, you could put that in a table in your sheet and just refer to it with cell ranges:
    Code:
    	  M	  N
1	0	no way
2	50000	*
3	100000	**
4	200000	***
5	300000	****
6	500000	*****
7	750000	Silver
8	1000000	Gold
9	1250000	Platinum
    =LOOKUP(F20, $M$1:$M$9, $N$1:$N$9)
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #22

    Oct 14, 2009, 12:51 PM
    I would not have concluded that these two threads constituted the same thing. The first question was FAR more complicated than the current topic.
    Helpinlasvegas1's Avatar
    Helpinlasvegas1 Posts: 10, Reputation: 1
    New Member
    		  
    #23

    Oct 14, 2009, 01:45 PM

    The first question I posted was more complicated, I had to have a number that posted, but there are two separate categories, that is why the first is more complicated. The current topic was easier for me, and thank you for all yor help
Not your question? Ask your question View similar questions
 
Page 2 of 2 « First < 2

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Budgie nesting box [ 5 Answers ]

Hi I have an aviary and I have some questions. 1/ does the nesting box have to be hang up, or can it just be put on top of anything? 2/ how long till my birds get used to the new avairy? Thanks and best regards, Wagdi

Levels of nesting in a formula [ 12 Answers ]

Dear All, I created an excel file with extension .xls and entered a forumla =if(... It had 11 levels and it successfully worked and I saved it. Next day when I have opened the file it gave the error #value. I entered the formula again but it refused to accept with the following message: "The...

Nesting If Function [ 1 Answers ]

I have a formula that I am using in Excel 2007 to indicate whether a person was contacted (Column V) and the date on which they were contacted (Column W). I do not want it to overwrite an existing date nor do I want it to change every date to the Today() date in previously entered cells. My current...

Nesting Syndrome [ 2 Answers ]

Ok so as many of you know I am 23 weeks pregnant with my third child, this pregnancy has had a lot of ups and downs (bleeding about five times during the first trimester, now placentia previa in the second) I can only imagine what the third trimester will bring. But, I thought I would take a few...

View more questions Search