Display Formula in Cell with values

Closed
ahamadbasha Posts 1 Registration date Monday July 8, 2013 Status Member Last seen July 8, 2013 - Jul 8, 2013 at 03:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 9, 2013 at 12:00 PM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jul 9, 2013 at 12:00 PM
Hi Ahamadbasha,

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

Best regards,
Trowa
0