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

	A	B	C	D	E	F
1	Cash	Stationery		{formula = }Cash - Stationery
2	Cash	Cards		{formula = }Cash - Cards
3
4	Cheque	Rooms		{formula = }Cheque - Rooms
5
6	EFT	Stationery		{formula = }EFT - Stationery
7	EFT	Cards		{formula = }EFT - Cards

<tbody>
</tbody>

 

[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,"")

	A	B	C	D	E
1	Cash	Stationery		Cash - Stationery
2	Cash	Cards		Cash - Cards
3	TextA01	TextB02
4	Cheque	Rooms		Cheque - Rooms
5	TextA02	TextB03
6	EFT	Stationery		EFT - Stationery
7
8	TextA03	TextB04
9	ETF	Cards
10
***	********	**********	**	****************	**

<tbody>
</tbody>

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