Cell Formatting

[ADE2]

Hi

I have the following formula in cell W10

=IF(X10="daily",U10,IF(X10="5 min",V10))

Cell U10 displays a date

Cell V10 displays a time


I think i need to add something to the formula to change the cell
formatting of W10,so that it changes between date and time format when
X10 displays Daily or 5 min.



Thanks

 

[Frank Kabel]

Hi
a formula can't change a cell format. It can only return values