Forum Discussion
Excel basic IF statement does not work
I have an issue with using the IF function. Originally I wanted to only execute a specific function if todays date was after a certain date. I used =IF(TODAY()>=DATEVALUE("01/03/2022"), SUM(D3;-D...
Hello DertjeR! There were errors in the syntax of your IF function. Try this:
=IF(TODAY()>=1/3/2022,SUM(D3,-D8,D9),"")
If possible, i would urge you to use a cell reference instead of hard coding the date in the "Logical Test" argument of the IF function.
Example: =IF(TODAY()>=D1,SUM(D3,-D8,D9),"") where cell D1 contains the date 1/3/22.
=IF(TODAY()>=1/3/2022,SUM(D3,-D8,D9),"")
If possible, i would urge you to use a cell reference instead of hard coding the date in the "Logical Test" argument of the IF function.
Example: =IF(TODAY()>=D1,SUM(D3,-D8,D9),"") where cell D1 contains the date 1/3/22.