<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to use the if statement such that it checks for a condition in column A and returns the date and value in a cell from columns C and D respectively.<br />
The problem is that column C is a date column and column D is a float value. The following line then forms a weird format for the date and combines it with value in column D.<br />
<br />
=IF(D8&gt;3,C8&amp;&quot; &quot;&amp;D8,0)<br />
<br />
How do I rectify this?<br />
<br />
Thanks<br />
Shilpi
</div>
</div>


Hi,

I am trying to use the if statement such that it checks for a condition in column A and returns the date and value in a cell from columns C and D respectively.
The problem is that column C is a date column and column D is a float value. The following line then forms a weird format for the date and combines it with value in column D.

=IF(D8>3,C8&" "&D8,0)

How do I rectify this?

Thanks
Shilpi

excel if statement print

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