Forum Discussion
IF Formula Help
Hi! Can someone help me put together a string of multiple IF formulas? See the table below. I want the Progress Column to show the percentages associated with what is filled in for the Status ...
The anomalies in the rounding make this one a bit longer but here goes:
=LET(
n, COLUMNS(matrix),
filled, (LEN(matrix) <> 0) * 1,
multiplier, SEQUENCE(n, , 1, 0),
m, MMULT(filled, multiplier),
SWITCH(m, 6, 0.65, 7, 0.9, 8, 1, m / 10)
)
