IF function - urgent

[mladen_ninja]

Hello gurus,

I have an urgent issue.

=DAYS360(**IF**;NOW();TRUE)

In upper formula I need to replace **IF** with a formula that will use the value in cell J2, or H2 (if there is nothing in J2), or K2 (if there is nothing in J2).

Important: If there is value in all cells, the value in J2 have to be used, or if there is a value in H2 and K2, the value from H2 should be used...

God Bless You,
BR, Mladen

 

[cornflakegirl]

Welcome to the board.

Try:

=IF(J2<>"",J2,IF(H2<>"",H2,K2))

 

[mladen_ninja]

Thank you.

That`s it! Thank You for the answer. I spent 1h to solve this date issue.
Your help is highly appreciated.

BR, Mladen