View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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 :)