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.

CAN A VALUE BE RETURNED WHEN TEXT IS ENTERED IN A DIFFERANT CELL?
 

=IF(A1="R",15,0) or =15*(A1="R") and copy down.
--
David Biddulph


AL wrote:
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.