percentage return on charcters not numbers

[Kent]

Have a spreadsheet where the end result is "current" or "expired" and I am
required to place a percentage return on the current return but as they are
not numeric I cant determine exactly how to represent the returns as 1 or 0
to gain a percentage return
Any help please
Kent

 

[Dave F]

If I understand you correctly, you want a number to represent each of
"current" and "expired" and calculate percentages based on those number
placeholders?

Try something like this: =IF(A1="current",1,IF(A1="expired",0,"")) and then
you have your numerical values with which you can run calculations.

Is that what you had in mind?

The formula above assumes that "current" or "expired" is in A1; change to
suit your needs.

Dave