I am attempting to add 4 cells into 1 with "+" in between the first three results and "=" at the end.
Cell M7 is where I started my formula. If all 4 cells are filled in the formula works great but anything less my formula bombs. The + and = are always left behind and looks like the following.
AR+HE+HU+0=5
HE+IU+0+0=9
or if all other cells are blank
+++=
Being each cell can vary in data, the formula would need to be dynamic in order to display what is in each cell with the right characters needed.
Current formula in use =IF(COUNTA(H7),B7&"+"&D7&"+"&F7&"+"&H7,IF(COUNTA(F7),B7&"+"&D7&"+"&F7,IF(COUNTA(F7),B7&"+&D10","")))&"="&K7
I even attempted to use concentrate, but I get the same results
What set of formulas will i need to make this happen.
B6 | C6 | D6 | E6 | F6 | G6 | H6 | I6 | J6 | M6 (FORMULA) |
VE | AR | LO | DH | 3 | VE+AR+LO+DH=3 | ||||
AR | HE | HU | 5 | AR+HE+HU=5 | |||||
HE | IU | 9 | HE+IU=9 |
Cell M7 is where I started my formula. If all 4 cells are filled in the formula works great but anything less my formula bombs. The + and = are always left behind and looks like the following.
AR+HE+HU+0=5
HE+IU+0+0=9
or if all other cells are blank
+++=
Being each cell can vary in data, the formula would need to be dynamic in order to display what is in each cell with the right characters needed.
Current formula in use =IF(COUNTA(H7),B7&"+"&D7&"+"&F7&"+"&H7,IF(COUNTA(F7),B7&"+"&D7&"+"&F7,IF(COUNTA(F7),B7&"+&D10","")))&"="&K7
I even attempted to use concentrate, but I get the same results
What set of formulas will i need to make this happen.