Display Formula in Cell with values

Closed
Report
Posts
1
Registration date
Monday July 8, 2013
Status
Member
Last seen
July 8, 2013
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
i need to display the used formula in another cell as it is with substituting the values.

example:
if A1=100, A3=200, B1=206
formula is =SUM(A1, A3,B1) then i need to display the formula in adjacent cell as SUM(100,200,206)

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Ahamadbasha,

To get the result you are after use this:
="SUM("&A1&","&A3&","&B1&")"

Best regards,
Trowa
0