# Multiple if statements to have a percentage

#### polska2180

##### Active Member
Hi, I'm not even sure how to title this and as such unable to find a solution which i'm sure is out there. Basically I'm looking to do a formula that says

Basically i have 5 cells at as each gets filled out cell a1 would increase by 20 % so if A1 is "" then "" else 20% unless b1 is filled then 40% unless c1 is filled the 60% all the way to 100%.

Thanks.

#### jtakw

##### Well-known Member
Hi,

If the data cells do not contain a formula producing a Blank ( "" ) result, you can do it this way, works for Both Text and Numeric data:

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">this</td><td style=";">that</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">40%</td></tr></tbody></table><p style="width:6.4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet677</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F1</th><td style="text-align:left">=IFERROR(<font color="Blue">1/(<font color="Red">1/COUNTA(<font color="Green">A1:E1</font>)</font>)*0.2,""</font>)</td></tr></tbody></table></td></tr></table><br />

Format result cell as Percentage.

If you Do have formulas in the data cells, we'll tweak the formula to accommodate.

#### polska2180

##### Active Member
This is perfect because its not dependent on the previous cell so if somebody skips one it will still report % completed. TY.

NOTE: in my actual worksheet the cells were not next to each other so I just put comma ie A1,C1,E1 etc.

#### jtakw

##### Well-known Member
You're welcome, glad it works for you.