nested if function

[compman]

What is the syntax needed to perform 2 or more IF statements? For example, if in one cell, there are 4 possible entries, and you want to match them to certain values, is it possible? Let's say in cell A1, one can enter the values 1,2,3,or 4. In B1 you want to write an equation that will give you an assigned value for each one. 1=100,2=200,3=300,or 4= 400. How is that done?

 

[NikNik]

This syntax is as follows:

=IF(A1=1,100,IF(A1=2,200,IF(A1=3,300,IF(A1=4,400))))

However you may want to look at writing the function in code and passing A1 to it then using Select Case to determine the return value.

 

[eliW]

On 2002-08-27 07:46, compman wrote:
What is the syntax needed to perform 2 or more IF statements? For example, if in one cell, there are 4 possible entries, and you want to match them to certain values, is it possible? Let's say in cell A1, one can enter the values 1,2,3,or 4. In B1 you want to write an equation that will give you an assigned value for each one. 1=100,2=200,3=300,or 4= 400. How is that done?

Hi compman and welcome to the board.

in B1 you enter:

=IF(A1=1,100,IF(A1=2,200,IF(A1=3,300,400)))

But no more then 7 nests.

VLOOKUP function though is a better choise here.

Eli

 

[lenze]

If your values are in fact, 1,2,3,etc. You can use the CHOOSE Function

=CHOOSE(A1,100,200,300,...)

 

[compman]

Thanks folks. You're wonderful.