Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |