Author Topic: Nested IF - AND - OR - NOT Excel Statements  (Read 798 times)

Offline JimS

  • Senior Poaster
  • ***
  • Posts: 530
Nested IF - AND - OR - NOT Excel Statements
« on: Jul 16, 2009, 01:31 PM »
"I shall pass through this world but once.  Any good I can do, or any kindness that I can show any human being, let me do it now and not defer it, for I shall not pass this way again."
 - Stephen Grellet

Offline Chandler

  • Universal Moderator
  • xTreme Poaster
  • *****
  • Posts: 4069
    • Quantex Zone
Re: Nested IF - AND - OR - NOT Excel Statements
« Reply #1 on: Jul 16, 2009, 01:35 PM »
=IF(MAX(G2,0.15)>F2, "Yes", "No")

Offline JimS

  • Senior Poaster
  • ***
  • Posts: 530
Re: Nested IF - AND - OR - NOT Excel Statements
« Reply #2 on: Jul 16, 2009, 01:52 PM »
Thanks for fast response, Chandler.  It didn't work though.  If I have 0.08 in F2 and 0.07 in G2, the result should be "No", because F2 is less than 0.15.  However, I just tried this, and it seems to work:
=IF(AND(F2>0.15,F2>G2),("Yes"),("No"))

How does this look to you?  I need to check it to make sure it's working in all scenarios.  I also need to read up on the MAX argument; I've never used it.

Thanks again.
"I shall pass through this world but once.  Any good I can do, or any kindness that I can show any human being, let me do it now and not defer it, for I shall not pass this way again."
 - Stephen Grellet

Offline JimS

  • Senior Poaster
  • ***
  • Posts: 530
Re: Nested IF - AND - OR - NOT Excel Statements
« Reply #3 on: Jul 16, 2009, 04:40 PM »
Chandler, I stand (actually, I'm sitting) corrected...

The only thing wrong with your formula was the order of the "Yes" and "No".  Switch 'em around and much happiness and joy return.  I stared at this dang dang thing for so long I thing I was cross-eyed a few times over.

Thanks again.
"I shall pass through this world but once.  Any good I can do, or any kindness that I can show any human being, let me do it now and not defer it, for I shall not pass this way again."
 - Stephen Grellet

Offline Mark H

  • "H" is for handy
  • xTreme Poaster
  • *****
  • Posts: 3098
Re: Nested IF - AND - OR - NOT Excel Statements
« Reply #4 on: Jul 16, 2009, 09:58 PM »
Glad you got it worked out Jim.

Mark H
Enjoy the nature that is around you rather than destroying it.