nested ifs

[dave glynn]

Cell C1 takes is value from any one of three other cells depending on the
value of cell B4. The if statement I should like to writr would go something
like this

if(b4=1,b1&if(b4=2,b2&if(b4=3,b3)))

Is this syntax correct?

Many thanks

Dave

 

[Sean Timmons]

& is used for concatenation.

=IF(B4=1,B1,if(B4=2,B2,if(B4=3,B3,"")))

But, you can alternately do:

=INDIRECT("B"&B4)

 

[Tom Hutchins]

Try this in C1

=IF(B4=1,B1,IF(B4=2,B2,IF(B4=3,B3,"")))

The "" is what is returned if B4 is not 1, 2, or 3.

Hope this helps,

Hutch

 

[Joe User]

If B4 will contain only 1, 2 or 3, you could use:

=CHOOSE(B4,B1,B2,B3)

As for the IF syntax, I suspect you want:

=IF(B4=1, B1, IF(B4=2, B2, B3))


----- original message -----

 

[dave glynn]

Mny thanks Sean

& is used for concatenation.

=IF(B4=1,B1,if(B4=2,B2,if(B4=3,B3,"")))

But, you can alternately do:

=INDIRECT("B"&B4)