User Profile
ac520
Copper Contributor
Joined Jul 06, 2023
User Widgets
Recent Discussions
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%
