Kenci
Kenci

Reputation: 4882

How to write a correct AND function?

I have two cells

MIN DATE: 2008-01-01 ($H10)
MAX DATE: 2012-02-01 ($H11)

I want to check if the value in $B16 is greater than MIN date AND less or equal to MAX DATE

This is what i write:

=AND($B16>$H10, $B16<=$H11)

the result is: parse error.

What am i doing wrong?

Upvotes: 0

Views: 63

Answers (1)

Cutter
Cutter

Reputation: 1820

Replace the comma (",") with a semicolon (";").

Upvotes: 1

Related Questions