I need help with adding a suffix

[rowie]

I want to add a suffix, but only if it is greater than 0. Google wasn't helping me.

This is what I got so far.
=CONCATENATE(D2,"BF")


Thanks

 

[FormR]

Hi - maybe:

=IF(D2>0,D2&"BF",D2)

 

[rowie]

Yeah that did it, cheers.
I have copy and pasted that into multiple rows, with a different suffix for each column, now i need to combine the values into one cell, using =L2&" "&M2&" "&N2&" "&O2&" "&P2&" "&Q2&" "&R2&" "&S2, but i'm getting unwanted zeroes on empty cells.

Joining both formulas would be nice.

Thanks

 

[FormR]

Try using this in L2 copied across to S2 and down as far as needed:

=IF(C2="","",C2&C$1)

 

[rowie]

You are a Superstar, thank you very much.

 

[rowie]

Hopefully one last thing. Using =N3&"+"&O3&"+"&P3&"+"&Q3&"+"&R3&"+"&S3&"+"&T3&"+"&U3 I only want the pluses to be on between 2 values.

Thanks

 

[FormR]

Try:

=SUBSTITUTE(TRIM(N3&" "&O3&" "&P3&" "&Q3&" "&R3&" "&S3&" "&T3&" "&U3)," ","+")

 

[rowie]

That didn't work, but i did bodge a solution. All I did was add a space after the value in B1 to I1, it's not a plus, but it'll do. Cheer for the help again.

 

[FormR]

That didn't work, but i did bodge a solution.

Works here; maybe you have culmination of "bodges" that make your set-up different

Excel Workbook
	M	N	O	P	Q	R	S	T	U
2	A+B+C+D		A		B		C		D
3	A+B				A				B
4	A+B+C	A	B	C
Sheet1

Cheer for the help again.

No Problem.