Multiple if statements to have a percentage

polska2180

Active Member
Joined
Oct 1, 2004
Messages
344
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
Joined
Jun 29, 2014
Messages
5,146
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
Joined
Oct 1, 2004
Messages
344
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.
 

Forum statistics

Threads
1,077,822
Messages
5,336,566
Members
399,088
Latest member
Swindlestikz

Some videos you may like

This Week's Hot Topics

Top