If formula: if A1 is greater than B1 and A1 is greater than zero..

[Jason]

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

 

[Michael]

Jason

I would add a second IF statement in there:

=IF(F2>0,
(IF(G2>=F2,"YES","NO"),
"NO")
)

I think the format is correct, but did not test it.....

 

[Mike H]

Hi,

Use AND

=IF(AND(F2>0,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.