nested ifs

  • Thread starter Thread starter dave glynn
  • Start date Start date
D

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
 
& is used for concatenation.

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

But, you can alternately do:

=INDIRECT("B"&B4)
 
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
 
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 -----
 
Back
Top