Display Formula in Cell with values

Closed
ahamadbasha Posts 1 Registration date Monday 8 July 2013 Status Member Last seen 8 July 2013 - 8 Jul 2013 à 03:54
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 9 Jul 2013 à 12:00
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
9 Jul 2013 à 12:00
Hi Ahamadbasha,

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

Best regards,
Trowa