<div>
Try This <b><i>=IF(AND(C49=&quot;X&quot;,C50=&quot; &quot;),D36,IF(AND(C50=&quot;X&quot;,C49=<wbr />&quot; &quot;),D37,IF(AND(C49=&quot;X&quot;,C50=<wbr />&quot;X&quot;),(D36+<wbr />D37)/2,&quot;&quot;)<wbr />))</i></b><br />
<br />
Thanks
</div>


Try This =IF(AND(C49="X",C50=" "),D36,IF(AND(C50="X",C49=" "),D37,IF(AND(C49="X",C50="X"),(D36+D37)/2,"")))

Thanks

<div>
Formula only works if C49 and C50 contain X! &nbsp;If only C49 or only C50 contain an X, then value is blank.
</div>


Formula only works if C49 and C50 contain X!  If only C49 or only C50 contain an X, then value is blank.

<div>
That did the trick,<br />
<br />
Thanks,<br />
<br />
Bill
</div>


<div>
<div class="content wysiwyg-content">
If C49 = X and C50= &quot;&nbsp;&quot;, then the value of D36<br />
If C50 = X and C49= &quot;&nbsp;&quot;, then the value of D37<br />
If both C49=X and C50 = X, then the value of D36+D37/2
</div>
</div>


If C49 = X and C50= " ", then the value of D36
If C50 = X and C49= " ", then the value of D37
If both C49=X and C50 = X, then the value of D36+D37/2

Value of a cell in Excel based on multiple factors

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

Microsoft Excel

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.

Office Suites-Other

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.