<div>
Sorry, that should be Compound, not Comany
</div>


Sorry, that should be Compound, not Comany

<div>
Well, the structure has changed slightly but your answer has sent me in the rights direction. &nbsp;Thanks.
</div>


Well, the structure has changed slightly but your answer has sent me in the rights direction.  Thanks.

<div>
<div class="content wysiwyg-content">
I have Cells N7, P7, R7 AND T7. &nbsp;<br />
Either N7, P7 or T7 should contain the letter X. &nbsp;<br />
Cell M8 should test for the existence of X in N7, P7, or &nbsp;T7. &nbsp;<br />
If only N7 is checked M8 should contain the value of O7 which is text with the word Pure and a space in front of the text value of O7. <br />
If only P7 is checked, M8 should contain the value of Q7 which is text with the word Pure and a space in front of the text value of Q7. R7 should not be checked by itself. <br />
If T7 is checked, M8 should contain the value of U7 which is text. <br />
When R7 is checked in conjunction with N7, M8 should contain the value of S7 which is text with the letter d at the end of the text value of S7 a space and the value of O7 which is text.<br />
When R7 is checked in conjunction with P7, M8 should contain the value of S7 which is text with the letter d at the end of the text value of S7 a space and the value of Q7 which is text. <br />
N7 and P7 should never both be checked together.<br />
I have attached a file with a partially working formula in M8.<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/06_w26/919758/AREA2Sample.xls" target="_blank" class="file-inline" title="Excel Spreadsheet file containing example (110 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>AREA2Sample.xls</a>
</div>
</div>


Excel Spreadsheet file containing example

AREA2Sample.xls

I have Cells N7, P7, R7 AND T7.  
Either N7, P7 or T7 should contain the letter X.  
Cell M8 should test for the existence of X in N7, P7, or  T7.  
If only N7 is checked M8 should contain the value of O7 which is text with the word Pure and a space in front of the text value of O7. 
If only P7 is checked, M8 should contain the value of Q7 which is text with the word Pure and a space in front of the text value of Q7. R7 should not be checked by itself. 
If T7 is checked, M8 should contain the value of U7 which is text. 
When R7 is checked in conjunction with N7, M8 should contain the value of S7 which is text with the letter d at the end of the text value of S7 a space and the value of O7 which is text.
When R7 is checked in conjunction with P7, M8 should contain the value of S7 which is text with the letter d at the end of the text value of S7 a space and the value of Q7 which is text. 
N7 and P7 should never both be checked together.
I have attached a file with a partially working formula in M8.

Company IF(AND) Statement in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.