If and concatenate formula

[avh]

Hi there,

Is anyone able to help me with a formula for the following?

If value in cell A is 0 then concatenate cells B, C and D but if value in cell A is not 0 then concatenate cells A, C and D.

Thanks in advance

 

[NARAYANK991]

Hi ,

Cell A is not a cell ; cell A1 or A2 or A3 or ... is.

Your formula can be :

=IF(A1 = 0 , B1 & C1 & D1 , A1 & C1 & D1)

Narayan

 

[Hui]

=IF(A1 = 0 , B1, A1 ) & C1 & D1)

 

[avh]

Thanks you both for your responses. That's exactly what I needed!