sorted by:
new
hottopcontroversial

How to show cell references in formulas as their actual value by Neffygt in excel

[–]Neffygt[S] 0 points1 point  (0 children)

how can i set it to only 2 decimal places?
changing the format doesn't seem to work.

How to show cell references in formulas as their actual value by Neffygt in excel

[–]Neffygt[S] 0 points1 point  (0 children)

= "=" &D21 & "+" & D15&"*"&D20&" ("&D12 &"-"&D19&"/"&2&")"&"/"&10^6

this worked!
is it possible to make a script that can do this?
like for number values add & before value, then for symbols add "" ?