Previous Topic Next Topic

Excel IF statement

Closed
mkalkoske Posts 1 Registration date Tuesday August 28, 2018 Status Member Last seen August 28, 2018 - Updated on Aug 28, 2018 at 05:33 PM
 Blocked Profile - 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

Related:

1 response

Answer 1 / 1
Blocked Profile
Aug 28, 2018 at 04:58 PM
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!

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses