<div>
he has this currently <br />
<br />
=IF(B7&lt;5,&quot;Yes&quot;,&quot;No&quot;)<br />
<br />
and we assume it is correct :) no matter what he put in sentence :) <br />
and he wants &quot;&quot;&nbsp;if B7 is blank + current logic o/w<br />

</div>


he has this currently

=IF(B7<5,"Yes","No")

and we assume it is correct :) no matter what he put in sentence :)
and he wants "" if B7 is blank + current logic o/w


<div>
<div class="content wysiwyg-content">
=IF(B7&lt;5,&quot;Yes&quot;,&quot;No&quot;)<br />
<br />
Please can you help me amend the formula so that if B7is blank = &quot;&quot;&nbsp;the formula will also return a result of blank.<br />
<br />
However should B7 be greater than 5 (&lt;5) it will return &quot;No&quot;<br />
Less than or equal to 5 &quot;Yes&quot;<br />
<br />

</div>
</div>


=IF(B7<5,"Yes","No")

Please can you help me amend the formula so that if B7is blank = "" the formula will also return a result of blank.

However should B7 be greater than 5 (<5) it will return "No"
Less than or equal to 5 "Yes"



Formula help

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