nested ifs
 

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

nested ifs
 

& is used for concatenation.

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

But, you can alternately do:

=INDIRECT("B"&B4)

"dave glynn" wrote:

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

nested ifs
 

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

"dave glynn" wrote:

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

nested ifs
 

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" wrote in message
...
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

nested ifs
 

Mny thanks Sean

"Sean Timmons" wrote:

& is used for concatenation.

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

But, you can alternately do:

=INDIRECT("B"&B4)

"dave glynn" wrote:

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