ExcelBanter - If / Or Values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If / Or Values (https://www.excelbanter.com/excel-discussion-misc-queries/230082-if-values.html)

Canon

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

Jacob Skaria

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

All times are GMT +1. The time now is 06:03 PM.