Home > Mobile >  Display Summation in Google Sheets
Display Summation in Google Sheets

Time:10-03

I would like to have a cell in Google Sheets to display the entire summation for example:

5 5 = 10

If I do the following:

=5 5

The cell will only show 10 it doesn't show the 5 5.

Another way I have tried is:

="5 5 = " &5 5

While this works, if I need to modify the formula I have to change the formula in the quotes and after the & sign.

Is there a way to simplify this so that if I need to change the formula, I only have to touch the formula once in the cell?

CodePudding user response:

enter image description here

arrayformula would be:

=IFNA(BYROW(A1:A10; LAMBDA(xx; SUBSTITUTE(FORMULATEXT(xx)&"="&xx; "=";;1))))

enter image description here

  • Related