If And or If Then Statement

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!
 
P

Pete_UK

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
 
Top