I want to combine numerical value and text (commenting on an value)-CodePudding

I’ve a value eg: 3,100,000.24 in a cell, which I want to mention in comments automatically.

Eg: Increase in xx by 3.1MM

I tried using formula:

="Decrese in X by "&TEXT(J22,"[<999950]0.0,"K";[<999950000]0.0,,"M";0.0,,,"B"")

However, it gives me an error.

Can someone please help me on this.

Issue is related to excel.

Thanks in advance..

CodePudding user response：

Not sure if I get what you want to do, but in TEXT(J22,"[<999950]0.0,"K" the quotes before K matches the one before [<999950]0.0,, closing the text and leaving your K is loose in the formula. Similar thing with the M and B.

CodePudding user response：

Edit: see comment from Ron

———-