Formula with multiple conditions
I am currently trying add more conditions to my formular so as to give me different outcomes.
=IF([Funding Stream]@row = "BCP Core", "Kellyz", "Mwamba")
This is my current formular. I would however like to add more conditions such that if "BCP Core" is selected by a user in the Funding Stream, then the name Kellyz comes up, if a user selects "BCP Trust", "Livelihood Fund", "GRZ Fund" or "LZRP Cons", then the name Mwamba comes up, then if a user selects "KZCFP", "KZCFP GRZ Fund", "GLTFCA M", "Angola M", then the name Scarlet comes up.
Help Article Resources
Check out the Formula Handbook template!