Help with Excel Formula [Closed]

Report
-
 Blocked Profile -
Hello,
I am a beginner at Excel. Trying to figure out formula for:

IF DATE in column A is greater than DATE in column B, highlight.


1 reply


The syntax for IF is as follows:

=If(logic_test,true,false)

So, your formula would be:

=IF(A1>B1,"Some value printed","nothing displayed")

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!