| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if functions question
I have the following formula: =IF(B2:F2="ru", "Richard", IF(B2:F2="ma", "Martin", IF(B2:F2="bd", "Benita", IF(B2:F2="la", "Leslie", "")))) The problem is the range is not recognized. The formula only works for one column at a time because I want the result to happen below the range, say in column F, not at the end or with an extra column (like G or H). Do I need to use some COUNTIF idea? or something else? Thanks, rcu -- ulffersrc ------------------------------------------------------------------------ ulffersrc's Profile: http://www.excelforum.com/member.php...o&userid=26020 View this thread: http://www.excelforum.com/showthread...hreadid=393735 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Improvements for text finding functions | Excel Discussion (Misc queries) | |||
| Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
| Database Functions - question using formulas as criteria | Excel Worksheet Functions | |||
| PASTE DOWN FUNCTIONS | Excel Worksheet Functions | |||
| # of Functions per cell | Excel Worksheet Functions | |||
Threaded Mode
