Previous Topic Next Topic

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

Similar discussions

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

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses