Formula with multiple conditions

Taonga

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.

Paul Newcome

You will need a nested IF for this. There are a few examples of a nested IF in this article:

https://help.smartsheet.com/function/if