Excel IF statement

Posts
1
Registration date
Tuesday August 28, 2018
Last seen
August 28, 2018
-
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

See more 

Your reply

1 reply

Posts
10934
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 11, 2018
0
Thank you
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!
Respond to ac3mark