spreadshhet returns in "alpha" displayed as a total percentage

[Kent]

I have a spreadsheet for creditors listing only (current and expired) as
returns can someone please help me with some info regarding making exel
recognise the returns as either 1 or 0 and allow me to formulate a final
percentage.

Ps thx for all the help so far appreciated
Kent

 

[JE McGimpsey]

I have a spreadsheet for creditors listing only (current and expired) as
returns can someone please help me with some info regarding making exel
recognise the returns as either 1 or 0 and allow me to formulate a final
percentage.

I have no idea what constitutes a "final percentage", but if you mean
the percentage of entries that are current:

=COUNTIF(A2:A10000, "current")/COUNTA(A2:A10000)

or percentage of entries that are expired:

=COUNTIF(A2:A10000, "expired")/COUNTA(A2:A10000)

Format each as a percentage, of course.