Inserting current date instead of zero as a negative IF result

[BillDerr]

I have an IF function written as =IF(C37>0,C62,0)

I would like C62 to return the current date or some text instead of zero - is this possible?

Thanks.

[robleyd]

Yes; simply replace the zero with whatever other result you want. For example:

=IF(C37>0, C62, "Text here" )
=IF(C37>0, C62, TODAY() )

[BillDerr]

Thank you, that works perfectly.