CODEWITHSUNDEEP
google-sheetsjoinreplaceconcatenationgoogle-sheets-formula
Saku
Saku

Reputation: 365

Add info in cell without affect its value

I'm looking to show more information in one single cell but without altering its actual value.

For exemple
A2 is an addition
A2 = 40+10
Showed: A2 = 50

But I want to have this showed:
« 50 (40+10) » (the actual formula)

A2 keeps the value « 50 » but show me the actual maths behind

Is this possible?

Upvotes: 0

Views: 180

Answers (1)

player0
player0

Reputation: 1

in the same cell:

=40+10&" (40+10)"

0

in a side cell:

=A2&" ("&REPLACE(FORMULATEXT(A2), 1, 1, )&")"

0

Upvotes: 1

Related Questions