Having problems with a value output.

[Iszu]

Hello!

Im not super new to excel, but formula's and such still get me confused sometimes.

Here's the issue.

I have 5 Cells

B-C-D-E-F

Cell's C-D-E-F are drop down menu's with the value of "Yes" or "No"
Cell B is a "Percentage Complete" box (no formula just named % complete)

I need to create a formula that would add .25% to the "Percentage complete" box for every one of the 4 cells with a yes/no drop down where yes it will add .25% if no then it add's 0

So if cells C-D-E-F = No then the value of percentage complete = 0 but if C-E-D-F = Yes then percentage complete = 100%

Im having trouble finding the right formula to add a numeric value to a text result.

Please help!! Thank you for your time

[Andy Pope]

In B you can use this formula

="Percentage complete = " & TEXT(COUNTIF(C2:F2,"Yes")/4,"0%")

If you do not want the percentage complete text then just use

=COUNTIF(C2:F2,"Yes")/4

and format cell as percentage.

Assumes anything other than Yes in C:F is treated as No.

[Iszu]

Andy!

Thanks so much,

If you have a second can your sort of explain the logic behind that formula, Im looking to get a deeper understanding. That is of course, if you have the time to spare!

Additionally, does this add .25 into the percentage completed formula? I mean, for every "yes" result does it add .25 to the percentage complete field?

[Andy Pope]

The countif returns a count of the cells with Yes in for the range specified.
This value is then divided by 4, which is the number of cells in the range.

So possible answers will be.

0/4 = 0 = 0%
1/4 = 0.25 = 25%
2/4 = 0.5 = 50%
3/4 = 0.75 = 75%
4/4 =1 = 100%

If you range changes to be more or less than 4 cells you will need to change the divisor. So you could use,

COUNTIF(C2:F2,"YES")/COLUMNS(C2:F2)

[zbor]

Second is formula: it count IF text is YES.
(and divide by 4 wich is issue (0,25))

First formula use this one only write whole sentence:

= "WRITE SOMETHING" & "WRITE SOMETHING ELSE" & formula & B1 (for example)