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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF statement with 2 logicals 1
Page numbering with Merged Document and IF statements 1
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Creating tables based on looking down a column and back across a row 0
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) 7
IF statement not returning correct answer 3
multiple scenerios in excel 3
Nested IF statements using AND / OR 2

Top