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

  • Thread starter Thread starter Jason
  • Start date Start date
J

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 :)
 
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.....
 
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.
 
Back
Top