| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell not showing all the text entered? | Excel Discussion (Misc queries) | |||
| Auto Populate Data from cell to another sell in differant sheets | Excel Discussion (Misc queries) | |||
| Find a value in a cell and return another value in a differant cel | Excel Discussion (Misc queries) | |||
| Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Hybrid Mode
