If And or If Then Statement

  • Thread starter Thread starter Cecilia
  • Start date Start date
C

Cecilia

Hello--

I'm hoping someone can help with this statement:

=IF(AND(O7<-0.01,R7<-0.01),"Share Decrease & Fair Share
Gap",IF(O7<-.01,"Share Loss",IF(R7<-.01,"Fair Share Gap","NA))

The first part of this is looking for two conditions, if neither of those
are met, then I'd like to check for each one individually. I'm hoping someone
can help!
 
Just a few things missing. Try this:

=IF(AND(O7<-0.01,R7<-0.01),"Share Decrease & Fair Share
Gap",IF(O7<-.01,"Share Loss",IF(R7<-.01,"Fair Share Gap","NA")))

Hope this helps.

Pete
 
Back
Top