<div>
That's great thank-you!<br />
<br />
I've got an interesting question coming up you may be interested in.....<br />
<br />
Rob
</div>


That's great thank-you!

I've got an interesting question coming up you may be interested in.....

Rob

<div>
<div class="content wysiwyg-content">
I need a formula which returns the following result;<br />
<br />
If cell A1 + B1 is less than 1 return &quot;0&quot;, if A1+B1 is equal to or greater than 1 return &quot;1&quot;
</div>
</div>


I need a formula which returns the following result;

If cell A1 + B1 is less than 1 return "0", if A1+B1 is equal to or greater than 1 return "1"

What IF function

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