Excel: "IF" Formula in Excel

Hello, I need some help please! I am trying to create a formula in Excel 2013 that basically states, if in G2 is the text "Completed" then insert today's date in H2 This is what i have so far but it's not working! =IF("Completed"=(J17)=TRUE,"=Today()"=(K17)) I would really appreciate the help!

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of August 15, 2014.

For more resources for Microsoft Excel