How do I set formula?
 

I want Excel to calculate this problem, eg,
the problem is based on 4 levels of performance on school marks
level 1 = 0-39
level 2 = 40-59
level 3 = 60-79
level 4 = 80- 10

--
Zake
-----------------------------------------------------------------------
Zakes's Profile: http://www.hightechtalks.com/m29
View this thread: http://www.hightechtalks.com/t228889

How do I set formula?
 

=VLOOKUP(A1,{0,1;40,2;60,3;80,4},2)

--
Regards,

Peo Sjoblom

(No private emails please)


"Zakes" wrote in message
...

I want Excel to calculate this problem, eg,
the problem is based on 4 levels of performance on school marks
level 1 = 0-39
level 2 = 40-59
level 3 = 60-79
level 4 = 80- 100


--
Zakes
------------------------------------------------------------------------
Zakes's Profile: http://www.hightechtalks.com/m296
View this thread: http://www.hightechtalks.com/t2288892

How do I set formula?
 

Hi Zakes,

If I understand correctly..

In a desirable cell... =VLOOKUP(A1,B1:C4,2,1)

Where B1:B4 are 0, 40, 60, 80.
And C1:C4 are 1, 2, 3, 4
And the mark to evaluate is entered in A1

HTH
Regards,
Howard

"Zakes" wrote in message
...

I want Excel to calculate this problem, eg,
the problem is based on 4 levels of performance on school marks
level 1 = 0-39
level 2 = 40-59
level 3 = 60-79
level 4 = 80- 100


--
Zakes
------------------------------------------------------------------------
Zakes's Profile: http://www.hightechtalks.com/m296
View this thread: http://www.hightechtalks.com/t2288892