I am having trouble figuring out how to use fit 2 =SUM formulas into 1 cell with a seperator('/' or '|')

Formula 1: =SUM(Sheet2!E28) - 1 Formula 2: =SUM(Sheet3!C19) - 2

The result would be something like 1/2 or 1|2, is this possible?

CodePudding user response：

There are multiple ways to do that. One of simple way is to use concatenation operator &. Try-

=SUM(Sheet2!E28)-1 & "|" & SUM(Sheet3!C19)-2

Another way is to use TEXTJOIN().

=TEXTJOIN("|",TRUE,SUM(Sheet2!E28)-1,SUM(Sheet3!C19)-2)