IF Formula Help

Question

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 columns.

For example, if Column D has any value in it, then Column C (Progress) will show 10%

If Column D+E have any values, then Column C (Progress) will show 20%

If Column D+E+F have any values, then Column C (Progress) will show 30%

If Column D+E+F+G have any values, then Column C (Progress) will show 40%

If Column D+E+F+G+H have any values, then Column C (Progress) will show 50%

If Column D+E+F+G+H+I have any values, then Column C (Progress) will show 65%

If Column D+E+F+G+H+I+J have any values, then Column C (Progress) will show 90%

If Column D+E+F+G+H+I+J have any values, then Column C (Progress) will show 100%

sergeibaklan · Answer

ac520&nbsp;
As variant
=CHOOSE( COUNTA(D3:K3), 10%, 20%, 30%, 40%, 50%, 65%, 90%, 100% )
and drag it down

patrick2788 · Answer

ac520&nbsp;The anomalies in the rounding make this one a bit longer but here goes:=LET(
    n, COLUMNS(matrix),
    filled, (LEN(matrix) &lt;&gt; 0) * 1,
    multiplier, SEQUENCE(n, , 1, 0),
    m, MMULT(filled, multiplier),
    SWITCH(m, 6, 0.65, 7, 0.9, 8, 1, m / 10)
)&nbsp;&nbsp;

Forum Discussion

IF Formula Help

2 Replies

Resources