| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If / Or Values
Excel 2007
How can I change the following into a formula? If B46 = A. Len or R. Cha or G. Con, then show the value of cell B35, if B46 = J. Chi or R. Per or B. Lee, then show the value of cell C35 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If / Or Values
=IF(OR(B46="A. Len",B46="R. Cha",B46="G. Con"),B35,IF(OR(B46="J. Chi",B46="R.
Per",B46="B. Lee"),C35)) Put this in one line... If this post helps click Yes --------------- Jacob Skaria "Canon" wrote: Excel 2007 How can I change the following into a formula? If B46 = A. Len or R. Cha or G. Con, then show the value of cell B35, if B46 = J. Chi or R. Per or B. Lee, then show the value of cell C35 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 doesnt show Y-axis values when the values are small. | Charts and Charting in Excel | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Linear Mode
