Forum Discussion

Sneaky's avatar
Sneaky
Occasional Reader
Jun 07, 2026

Help with Formular to keep constants

Hi I have 2 rows for percentage values as per this table. C3 will be the value of (C2 + B3) / 2.  However I need to check for an empty value so my calculation is  =IF($B$3="",0, IF($C$2="",0,($C$2+...
excel
IlirU's avatar
IlirU
Iron Contributor
Jun 08, 2026

Sneaky​,

Below are three formulas that you can use. The first two formulas which are manual formulas are explained quite well by m_tarler​. The third formula is a dynamic formula.

  • First formula in cell C3. Drag it right and down.
=IF($B3 = "", 0, IF(C$2 = "", 0, (C$2 + $B3) / 2))
  • Second formula in cell C3. Drag it only down.
=IF($B3 = "", 0, IF(C$2:G$2 = "", 0, (C$2:G$2 + $B3) / 2))
  • Third formula in cell C3. No need to drag it.
=LET(
     row, B3:B4,
     col, C2:G2,
          --TEXTSPLIT(TEXTJOIN(";",, BYROW(row, LAMBDA(row, ARRAYTOTEXT(
          IF(row = "", 0, IF(col = "", 0, (row + col) / 2)))))), ", ", ";")
)

Format the cells as percentages.

Hope this helps.

IlirU