Conditional formula for multiple criteria

[SiddeshDhruva]

Hi Team,

I am working on the data and i need to map the data with multiple criteria's, the data has multiple rows and some has Supplier ID and some hasn't, so the logic should be

if the supplier ID has numbers in it then look for the stakeholder and spend column if all 3 has values then result should be "Good"

if the supplier ID has number and stakeholder column has information but spend is '0'  then 'Bad'

if the supplier ID has number and no stakeholder information and 0 spend then 'Very bad'

if supplier id has has number and no stakeholder information but has spend value then 'Better"

else Null

I have attached the excel file for the data example for your reference

Thank you!

Regards,

Dhruva

[atcodedog05 · Accepted solution]

Hi @SiddeshDhruva 

Here is how you can do it.

Workflow:

Hope this helps : )

[SiddeshDhruva]

Thanks a ton @atcodedog05 , it worked exactly how i wanted..

Regards,

Siddesh Dhruva

[atcodedog05]

Happy to help : ) @SiddeshDhruva 

Cheers and have a nice day!