Append value in Column A to an Formula

[Masond3]

All, 

Having a mental block, and struggling on how to proceed

I currently have a formula that populates a column called "Reason" when the [Financials ] = [Helper]

Formula  : IF [Financials ] = [Helper] THEN "Duplicate Products" ELSE [Reason] ENDIF

Current Output

Financials	Helper	Count	Reason
78961518.9	78961518.90	2	Duplicate Products
417298.14	417298.14	4	Duplicate Products

What i would like to do is when [Financials ] = [Helper] then append the "Count" within the reason

Desired Output

Financials	Helper	Count	Reason
78961518.9	78961518.90	2	2 Duplicate Products
417298.14	417298.14	4	4 Duplicate Products

Looking forward to your response 

Many thanks 

Masond3

[gawa · Accepted solution]

hi @Masond3 

You can put the "count" at the beginning of the word like this formula. You need to use ToString() function to concatenate numeric field to strings.

IF [Financials ] = [Helper] THEN ToString([Count])+" Duplicate Products" ELSE [Reason] ENDIF