Prev: Excel 2007 ate my fields
Next: moving entries between workbooks
From: AL on 31 Jan 2010 15:11
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.
From: "David Biddulph" groups [at] on 31 Jan 2010 15:39
=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.


 | 
Pages: 1
Prev: Excel 2007 ate my fields
Next: moving entries between workbooks