# 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 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% 2 Replies

# Re: IF Formula Help

As variant

``=CHOOSE( COUNTA(D3:K3), 10%, 20%, 30%, 40%, 50%, 65%, 90%, 100% )``

and drag it down

# Re: IF Formula Help

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)
)`````` 