ExcelBanter - How do I assign a numerical value to a textual entry to calculate percent completion?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I assign a numerical value to a textual entry to calculate percent completion? (https://www.excelbanter.com/excel-worksheet-functions/109405-how-do-i-assign-numerical-value-textual-entry-calculate-percent-completion.html)

mheavers

How do I assign a numerical value to a textual entry to calculate percent completion?

Hi guys, I have a spreadsheet that looks as follows

Packslip | Text | Photo | SEO | % Complete

440158 | 1 | 0 | 1 | 66%
440159 | 0 | 1 | 0 | 33%

The ones in this spreadsheet represent "complete" and the zeroes
represent "incomplete" -
The % complete field automatically calculates the total of the 3 stages
of completion and divides them by the number of stages (3) to
calculate a percentage. What I want to be able to do is write
"complete" in place of "1" and have it still asign a numerical value of
"1" in my formula. Is this possible? Thanks!

Mike

Toppers

How do I assign a numerical value to a textual entry to calculate

No ...cell contains either "Complete" or "1" not both. Why both? To get %
completion, use

=COUNTIF(B2:D2,"Complete")/3 formatted as %

HTH

"mheavers" wrote:

Hi guys, I have a spreadsheet that looks as follows

Packslip | Text | Photo | SEO | % Complete

440158 | 1 | 0 | 1 | 66%
440159 | 0 | 1 | 0 | 33%

The ones in this spreadsheet represent "complete" and the zeroes
represent "incomplete" -
The % complete field automatically calculates the total of the 3 stages
of completion and divides them by the number of stages (3) to
calculate a percentage. What I want to be able to do is write
"complete" in place of "1" and have it still asign a numerical value of
"1" in my formula. Is this possible? Thanks!

Mike

shail

How do I assign a numerical value to a textual entry to calculate percent completion?

Hi,
You might want to assign the values for "Complete" as 1 and for
"Incomplete" as 0 in a separate sheet and then you will VLOOKUP it when
one enters them below Text, Photo or SEO and the output will be
calculated as before.

Hope this will work fine with you.

Thanks,

Shail

mheavers wrote:
Hi guys, I have a spreadsheet that looks as follows

Packslip | Text | Photo | SEO | % Complete

440158 | 1 | 0 | 1 | 66%
440159 | 0 | 1 | 0 | 33%

The ones in this spreadsheet represent "complete" and the zeroes
represent "incomplete" -
The % complete field automatically calculates the total of the 3 stages
of completion and divides them by the number of stages (3) to
calculate a percentage. What I want to be able to do is write
"complete" in place of "1" and have it still asign a numerical value of
"1" in my formula. Is this possible? Thanks!

Mike

All times are GMT +1. The time now is 01:06 PM.