Multiple IF's

[Nanaia]

I have 7 codes that I need to convert to their corresponding value. I want to do this using IF, but felt nesting 7 of them is a bit excessive. I recall once getting a tip on how to put them all in one but can't seem to find it...unless I'm remembering wrong. It can be done can't it? I thought it would be a simpler formula than having IF in there 7 times. The criteria is as follows:
[TABLE="width: 405"]
<tbody>[TR]
[TD]=IF(CSV!AK3="E1",1.25)[/TD]
[/TR]
[TR]
[TD]=IF(CSV!AK3="V1","VAR")[/TD]
[/TR]
[TR]
[TD]=IF(CSV!AK3="L2.0","1.9375")[/TD]
[/TR]
[TR]
[TD]=IF(CSV!AK3="L2.5","2.4375")[/TD]
[/TR]
[TR]
[TD]=IF(CSV!AK3="L3.0","2.9375")[/TD]
[/TR]
[TR]
[TD]=IF(CSV!AK3="L3.5","3.4375")[/TD]
[/TR]
[TR]
[TD]=IF(CSV!AK3="L4.0","3.9375")

All help is always appreciated. I love learning this![/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[AlanY]

how about a lookup table like this?

Excel 2013/2016
	A	B	C	D	E
1	E1	1.25		L2.5	2.4375
2	V1	VAR
3	L2.0	1.9375
4	L2.5	2.4375
5	L3.0	2.9375
6	L3.5	3.4375
7	L4.0	3.9375
Sheet1

Cell Formulas
Range	Formula
E1	=VLOOKUP(D1,$A$1:$B$7,2,0)

 

[wideboydixon]

You can also hard-code the reference table if you don't want to put it in the sheet:

Book1
	A	B
1	E1	1.25
2	V1	VAR
3	L2.0	1.9375
4	L2.5	2.4375
5	L3.0	2.9375
6	L3.5	3.4375
7	L4.0	3.9375
Sheet1

Cell Formulas
Range	Formula
B1	=VLOOKUP($A1,{"E1",1.25;"V1","VAR";"L2.0",1.9375;"L2.5",2.4375;"L3.0",2.9375;"L3.5",3.4375;"L4.0",3.9375},2,FALSE)

WBD