IF formula imbedded with concatenation

[Peggy2015]

Hello,
How do I write a formula to:
1. Determine if a cell is labelled "Cash", "Cheque" or "EFT"
2. If it is then I need to concatenate certain cells together.

Example:


Thanks for your help.

Best wishes,
Peggy
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Cash[/TD]
[TD]Stationery[/TD]
[TD][/TD]
[TD]{formula = }Cash - Stationery[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Cash[/TD]
[TD]Cards[/TD]
[TD][/TD]
[TD]{formula = }Cash - Cards[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Cheque[/TD]
[TD]Rooms[/TD]
[TD][/TD]
[TD]{formula = }Cheque - Rooms[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]EFT[/TD]
[TD]Stationery[/TD]
[TD][/TD]
[TD]{formula = }EFT - Stationery[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]EFT[/TD]
[TD]Cards[/TD]
[TD][/TD]
[TD]{formula = }EFT - Cards[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[philwojo]

From your data I am not sure why you need an IF statement, if your data is laid out that way then you can just use concatenate.

 

[markmzz]

Hi!

Try this in D1 and copy down:

=IF(OR(A1={"Cash";"Cheque";"EFT"}),A1&" - "&B1,"")


[TABLE="class: grid, width: 331"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Cash[/TD]
[TD]Stationery[/TD]
[TD][/TD]
[TD]Cash - Stationery[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Cash[/TD]
[TD]Cards[/TD]
[TD][/TD]
[TD]Cash - Cards[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]TextA01[/TD]
[TD]TextB02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Cheque[/TD]
[TD]Rooms[/TD]
[TD][/TD]
[TD]Cheque - Rooms[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]TextA02[/TD]
[TD]TextB03[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]EFT[/TD]
[TD]Stationery[/TD]
[TD][/TD]
[TD]EFT - Stationery[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]TextA03[/TD]
[TD]TextB04[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]ETF[/TD]
[TD]Cards[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]***[/TD]
[TD]********[/TD]
[TD]**********[/TD]
[TD]**[/TD]
[TD]****************[/TD]
[TD]**[/TD]
[/TR]
</tbody>[/TABLE]


Markmzz

 

[Peggy2015]

Hello Mark,
Thanks for your help with the formula.
Best wishes,
Peggy

 

[markmzz]

Hello Mark,
Thanks for your help with the formula.
Best wishes,
Peggy

Hello Peggy,

You are welcome and thanks for the feedback.

I'm happy that my suggestion helps.

Markmzz