Help with Excel Formula

Closed

Annie - Nov 7, 2016 at 05:25 PM
Blocked Profile - Nov 7, 2016 at 05:26 PM

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 response

Answer 1 / 1

Blocked Profile
Nov 7, 2016 at 05:26 PM

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")