| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
