Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

IF Function - 2 Conditions,

Looking for help with this.  Here is the formual I wrote: Priority Status = if(TransfersBI[BOL Status]="In Transit",IF([Days in Transit]>10,"Alert",""), if(TransfersBI[BOL Status]="In Transit",IF([D...
Need Help
  • ChandeepChhabra's avatar
    ChandeepChhabra
    8 years ago

    Anonymous , Please try this

     

    =IF(Transfers[BOL Status]="In Transit",IF(AND(Transfers[Days in Transit]>=10,Transfers[Days in Transit]<=15),"Alert",IF(Transfers[Days in Transit]>15,"Priority")))

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this

 

=IF(TransfersBI[BOL Status]="In Transit",IF([Days in Transit]>15,"Priority",IF([Days in Transit]>10,"Alert",BLANK())),BLANK())

 

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

this gives me the error, "the end of input was reacched"