Forum Discussion

sleekpeek's avatar
sleekpeek
Regular Visitor
3 years ago

Formula Help Please

I have this formula in excel, i'd like to create the same in PBI.   =IF(W3<=-91,"Excluded",IF(W3>90,"Excluded",IF(W3>1,"Influenced",IF(W3<=0,"Sourced","Influenced")))   W3 in PBI would be: 'Opp C...
Need Help
sleekpeek's avatar
sleekpeek
Regular Visitor
3 years ago

thank you, I will try them both

  • confidentnwrong's avatar
    confidentnwrong
    Advocate I
    3 years ago

    If one of these work, please mark the answer as solution.
    Otherwise, provide more details, such as sample data of 'Opp Contact Role' without sensitive information.