Excel IF statement [Closed]

Report
Posts
1
Registration date
Tuesday August 28, 2018
Status
Member
Last seen
August 28, 2018
-
 Blocked Profile -
Hello,

I am trying to use the IF function with a date in the logic test cell; If the logice test cell has "Yes" then I want the todays date to show.

thanks

1 reply


The syntax for IF is as follows:

=IF(logic_test,True,False)

So, knowing that, we can go:

=IF(zz234=1.8,"the total is " & zz234,"sorry, the total didn't work out")



I hope this helped out!