View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
al al is offline
external usenet poster
 
Posts: 363
Default CAN A VALUE BE RETURNED WHEN TEXT IS ENTERED IN A DIFFERANT CELL?

I am trying to get one cell to return a specific value when another cell has
a letter
entered into it. example: If R is typed in a column serveral times on
differant rows the next column would return 15 as a value each time. Does
anyone know how I can do this? If something other than R is entered in the
column that uses text the corrasponding cel would return 0.