Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

If And or If Then Statement

2 views
Skip to first unread message

Cecilia

unread,
Sep 2, 2009, 9:12:01 PM9/2/09
to
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!

Pete_UK

unread,
Sep 2, 2009, 9:19:27 PM9/2/09
to
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

0 new messages