Logic Formulas

[kosborn]

I need to create a formula for a cell that has multiple tests with individual TRUE for each test...

example Slope is 1, 2, or 3. Each Slope has a differnet degree.

I need a formula the inputs the degree for each slope depending on what slope is enterered in a sperate cell.

In other words, if Column a is 1 then column B in the chart is 4, and if its 2 then the degree is 7.4, and so on....

I need Cell B26 to have an if formula that says if Cell B25 is equal to 1, then value should be 4, but if B25 is equal to 2 then value should be 7.4 and so on..... Can someone help?

 

[quikieemart]

I need to create a formula for a cell that has multiple tests with individual TRUE for each test...

example Slope is 1, 2, or 3. Each Slope has a differnet degree.

I need a formula the inputs the degree for each slope depending on what slope is enterered in a sperate cell.

In other words, if Column a is 1 then column B in the chart is 4, and if its 2 then the degree is 7.4, and so on....

I need Cell B26 to have an if formula that says if Cell B25 is equal to 1, then value should be 4, but if B25 is equal to 2 then value should be 7.4 and so on..... Can someone help?

Just keep using IF statements within a single IF statement. the '[value_if_false]' would be your next condition if the previous one doesn't meet. So this is what you'd put:

=IF(B25=1,4,IF(B25=2,7.4,IF(B25=........))) etc.

good luck

 

[kosborn]

Ok it will only let me nest 8 levels, which is fine I will cope but once I got it all entered it just replied false.... I need it to enter the if true value, I don't even have an if false value.

Do I need an If(Or( formula possibly?

 

[Scott Huish]

Have a look in the help file for the VLOOKUP function.

 

[kosborn]

Nevermind I got reference wrong base cell.... always something dumb or easy or both. Thank You!!!

 

[Scott Huish]

Excel Workbook
	A	B
1	9	10.11
Sheet1

Excel Workbook
	L	M
1	1	4
2	2	7.3
3	3	9
4	4	5
5	5	7
6	6	9
7	7	15
8	8	19.3
9	9	10.11
Sheet1