If / Or Values

C

Canon

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
 
J

Jacob Skaria

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max Formula 5
How to refer to a range except one cell 4
Scrabble Value calculation for Welsh words 0
Test cells for values if date matches 1
Average 10
Multiple AND/OR formulas 2
Test cells for values if date matches 1
how to design spreadsheets to collect data and display the totalmaterial used in a plating departmen 13

Top