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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!