Excel IF statement

mkalkoske 1 Posts Tuesday August 28, 2018Registration date August 28, 2018 Last seen - Aug 28, 2018 at 03:49 PM - Latest reply: ac3mark 10678 Posts Monday June 3, 2013Registration dateModeratorStatus October 19, 2018 Last seen
- Aug 28, 2018 at 04:58 PM
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

ac3mark 10678 Posts Monday June 3, 2013Registration dateModeratorStatus October 19, 2018 Last seen - Aug 28, 2018 at 04:58 PM
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