<div>
<div class="content wysiwyg-content">
I have two cells that contain If formulae. I would like to compare the two results and then display &quot;passed&quot; in a third cell<br />
<br />
CELL W5 Formula =IF(U5&gt;100,&quot;fail&quot;,&quot;clear&quot;)<wbr /><br />
<br />
CELL X5 Formula =IF(V5&gt;0.1,&quot;fail&quot;,&quot;clear&quot;)<wbr /><br />
<br />
I need CELL Y5 to display the word &quot;Passed&quot; if both W5 and X5 both equal &quot;clear&quot;<br />
<br />
or if you know an even easier way then suggestions accepted
</div>
</div>


I have two cells that contain If formulae. I would like to compare the two results and then display "passed" in a third cell

CELL W5 Formula =IF(U5>100,"fail","clear")

CELL X5 Formula =IF(V5>0.1,"fail","clear")

I need CELL Y5 to display the word "Passed" if both W5 and X5 both equal "clear"

or if you know an even easier way then suggestions accepted

Excel Formula IF X equals Y THEN Z

I have two cells that contain If formulae. I would like to compare the two results and then display &quot;passed&quot; in a third cell

CELL W5 Formula =IF(U5&gt;100,&quot;fail&quot;,&quot;clear&quot;)

CELL X5 Formula =IF(V5&gt;0.1,&quot;fail&quot;,&quot;clear&quot;)

I need CELL Y5 to display the word &quot;Passed&quot; if both W5 and X5 both equal &quot;clear&quot;

or if you know an even easier way then suggestions accepted

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