Google-sheets – Google Spreadsheets – How To Have 2 Functions Output Into 1 Box

google sheets

I'm using Google Spreadsheets and I'm currently trying to get multiple functions to output into 1 square. In my example:

={IF((B2-D2)>=0,"+"), SUM(B2-D2)}

I get the output I want +7, but it's in 2 different grid boxes | + | 7 |. How can I get both functions to output into the same box?

And this is just an example, so don't get hung-up on alternative workarounds

Google Spreadsheets Example

Best Answer

Then you have to use this formula:

=IF(B2-D2 >= 0, "+" & SUM(B2-D2))

The curly brackets are used for embedded arrays

Related Topic