View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kent kent is offline
external usenet poster
 
Posts: 37
Default percentage return on charcters not numbers

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