If formula: if A1 is greater than B1 and A1 is greater than zero..
Hi,
Use AND
=IF(AND(F20,G2=F2), "YES", "NO")
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Jason" wrote:
Hello everyone,
this is what I came up with so far:
=IF(G2=F2, "YES", "NO")
now I have to add F2 must also be greater than zero before putting a "YES"
how do i do that?
thank you :)
|