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

Excel IF statement
Fenix internet on bank statement - Guide
Excel if statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Excel date format dd.mm.yyyy - Guide
Excel free download - Download - Spreadsheets

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

How to use conditional format based on text?

How to calculate positions (1st,2nd,3rd...) in Excel

Similar discussions

Subscribe To Our Newsletter!