Need an IF statement that looks at a cell with =TODAY() and gives an amount

I have a table that is a VLOOKUP table where a Dropdown menu choice pulls certain amounts from the table. These amounts are going to change after a certain date. I have the =TODAY() in Cell AE5, and I was thinking that I could have an IF statement in each of the Column2 cells in Table1, that would state that the amount was 110 on or before 4/27/2020 and 120 after that.

I have attached a small sheet that shows all of the cells. Prior to distribution all of the cells to the right of column R will be Hidden from view and the sheet will be locked so that the calculating cells can't be accessed.

I hope this is possible. I just can't figure out the IF statement.

Thank You

chembel

Okay, when I place that formula in the cell I get the #NAME? error.

But, what worked was =IF(TODAY()<=AE5,110,120) and entering the deadline date into AE5. That way the system is finding out what today's date is a comparing it to the deadline on the form. Thanks for the suggestion. It helped me create what I needed.

Your help on this site is so generous. I appreciate all of the time that the people who moderate this site have given m. You people are so GREAT!!!!

You can mark this as Solved!!!

chembel