ExcelBanter - If And or If Then Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If And or If Then Statement (https://www.excelbanter.com/excel-worksheet-functions/241548-if-if-then-statement.html)

If And or If Then Statement

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!

If And or If Then Statement

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

On Sep 3, 2:12*am, Cecilia wrote:
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!