View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
abe
 
Posts: n/a
Default can a conditional formulas be setup using text to get a numerical

I want to set up a condtional formula that if I would enter a word like star
I would get a numercial result in the cell next to it like number 55, If I
type the word finsih in the same cell I would get a result 95

can this be done?