Thread: If formula: if A1 is greater than B1 and A1 is greater than zero..
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason Jason is offline
external usenet poster
  
Posts: 367
Default If formula: if A1 is greater than B1 and A1 is greater than zero..
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 :)
Reply With QuoteReply With Quote