View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jafferi[_2_] Jafferi[_2_] is offline
external usenet poster
 
Posts: 22
Default Multiple data entry with multiple results

How do I do a multiple data entry with different results

Cell A1 is the Data Entry cell.
Cell J1 is the result cell.

If I enter the word K in A1, J1 shows as 7:00
If I enter 9:00; J1 shows the same that is 9:00