If cell > Current date then show a 0, if not, reference a cell.

[Formulation]

I have this formula that obviously doesn't work but it shows what I'm trying to do.

Please Login or Register  to view this content.

C3: =TODAY()

Basically I need the formula to display a 0 until the date in C3 is 1/1/17 or later.
Once 1/1/17 passes, I need to display the contents of cell BB206
This formula will need to be in cell N6.

[Jonmo1]

Try

=IF(C3>=DATE(2017,1,1),BB206,0)

[Formulation]

Thanks! Working perfect now.

[Jonmo1]

You're welcome.