If formula gives blank cell, then run another function

[jeriss]

Please check the attachment.

In Cell D6, I applied the formula =LEFT(C3,4) to retrieve the first four digits of the Cell C6 which corresponds to the year of the bill. This works fine.

However, if Cell C6 is empty then it returns a blank cell. In this case, I want the cell to perform another similar formula that is to retrieve the year (YYYY) of the Cell F6 which is encoded in a Date format.

Can someone help me to combine both rules?

Thanks
Simon

[AliGW]

Try this:

=IF(C3="",YEAR(F3),LEFT(C3,4))

[jeriss]

Problem solved! Thank you so much!