Thread: Converting formulas from cell references to numbers
View Single Post
 
Old 07-19-2022, 08:40 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
On fly!

Leave the column with sum as it is. Add an empty column next to it, with formula like
Code:
= "" & Q6 & "+" & R6 & "+" & S6 & "+" & T6 & "+" & U6
NB! The added column displays all components of sum as string! You can take it as comment of formula.

And in case the components of original sum are formulas instead cell references, like:
Code:
= SUM(Formula1,Formula2,Formula3,Formula4)
in added column you use formula:
Code:
= "" & Formula1 & "+" & Formula2 & "+" & Formula3 & "+" & Formula3 & "+" & Formula4
Reply With Quote