| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Logical Test if statements with text--Excel 2002
I am trying to format a cell to check and see values for a range of other
cells. If the value of the cell is a text letter (r, y, g, or c) I want the value to be returned to be whatever letter it was. How can I do thies? |
|
#2
|
|||
|
|||
|
Logical Test if statements with text--Excel 2002
huh?
be returned to be whatever letter it was -- Don Guillett SalesAid Software "Matt" wrote in message ... I am trying to format a cell to check and see values for a range of other cells. If the value of the cell is a text letter (r, y, g, or c) I want the value to be returned to be whatever letter it was. How can I do thies? |
|
#3
|
|||
|
|||
|
Logical Test if statements with text--Excel 2002
One way, if I understand you correctly:
=IF(SUM(COUNTIF(A1,{"r","y","g","c"}))0,A1,"") In article , "Matt" wrote: I am trying to format a cell to check and see values for a range of other cells. If the value of the cell is a text letter (r, y, g, or c) I want the value to be returned to be whatever letter it was. How can I do thies? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
| get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
| Excel 2002: how to incr font size in option button text | Excel Discussion (Misc queries) | |||
| Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
| setting text qualifier in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
